Timeout Expired in Azure Data Sync

I'm getting the below error when trying to sync some large tables to Azure.  I read that the Timeout can be changed in the Sync Framework but not where to change it for the MS Data Sync Client.

id:DbProvider_RelationalSyncProvider_Exception, rId:, sId:0f270488-cf39-49c3-bde5-bb56131c4272, agentId:79fb8d08-df7d-45fd-9f1f-5ec43e7d036e, agentInstanceId:3eb5afb3-2fe8-4a87-9500-45a10b817838, syncGroupId:ac33f15d-40c7-4e11-9f8c-c840c8cd1732, syncGroupMemberId:87676d14-78b1-4c9f-91b5-811b693fd08a, hubDbId:69cf0214-1804-4475-8827-7f338e440a3e, tracingId:242635d9-b3fd-4e92-80b8-5018ac826199, databaseId:5ea2ae04-e919-4dfe-927e-e0cd9d5f4f62, sqlAzureActivityId:00000000-0000-0000-0000-000000000000, e:'Type=Microsoft.Synchronization.Data.DbSyncException,Message=Cannot enumerate changes at the RelationalSyncProvider for table 'dbo.ItemMovement'.  Check the inner exception for any store-specific errors.,Source=Microsoft.Synchronization.Data,StackTrace=   at Microsoft.Synchronization.Data.DbSyncBatchProducer.DequeueBatch()
   at Microsoft.Synchronization.Data.RelationalSyncProvider.ConsumeBatchFromProducer(DbSyncScopeMetadata scopeMetadata)
   at Microsoft.Synchronization.Data.RelationalSyncProvider.GetChanges(DbSyncScopeMetadata scopeMetadata, DbSyncSession DbSyncSession, UInt32 memoryBatchSize),'
'Type=System.Data.SqlClient.SqlException,Message=Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.,Source=.Net SqlClient Data Provider,StackTrace=   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   at Microsoft.Synchronization.Data.RelationalSyncProvider.EnumerateChangesInBatchesInternal(Object batchProducer),'
'Type=System.ComponentModel.Win32Exception,Message=The wait operation timed out,Source=,StackTrace=,', eType:'Type=Microsoft.Synchronization.Data.DbSyncException', eMessage:'Message=Cannot enumerate changes at the RelationalSyncProvider for table 'dbo.ItemMovement'.  Check the inner exception for any store-specific errors.', eTypeInner:'Type=System.Data.SqlClient.SqlException', eMessageInner:'Message=Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.' Error Code: -2146232060 - SqlError Number:-2, Message: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.. 
February 6th, 2015 1:52pm

It looks like this setting is in the AgentConfigData.xml file but it appears encrypted
Free Windows Admin Tool Kit Click here and download it now
February 6th, 2015 1:58pm

Wish the below link help.
http://blogs.msdn.com/b/sync/archive/2010/09/24/how-to-sync-large-sql-server-databases-to-sql-azure.aspx
February 11th, 2015 4:26am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics