Hi,

Recently I encounter some issues when try to sync data from an Azure SQL Database to another Azure SQL Database by SQL Data Sync (Review) serivce.

The following exceptions is getting from Windows Azure Management portal:

Sync failed with the exception "An unexpected error occurred when applying batch file C:\Resources\directory\a5aada091f5946db9054895c1236af01.NTierSyncServiceWorkerRole.BatchDir\DSS_aad33f80-a699-4ed0-b4d3-1403a3b5e4e4\sync_2ee7f82a6d9743babe249e3f948a950907270dbaddf5412b85a03bc09a0d166e\35fb73f6-2b67-4384-8150-68679fba688a.batch. See the inner exception for more details.Inner exception: Failed to execute the command 'UpdateCommand' for table 'dbo.XXX'; the transaction was rolled back. Ensure that the command syntax is correct.Inner exception: SqlException Error Code: -2146232060 - SqlError Number:40197, Message: The service has encountered an error processing your request. Please try again. Error code 40174. SqlError Number:0, Message: A severe error occurred on the current command.  The results, if any, should be discarded. " For more information, provide tracing ID aad33f80-a699-4ed0-b4d3-1403a3b5e4e4 to customer support.

Can anyone help to provide more information about this problem?

Thanks

Hi WeIIJ,

According to your error message, you need to check if there is some issue about your update command statement. If the update syntax is correct. I recommend you that reconnect to your SQL Database server, it will automatically connect you to a healthy copy of your database, then try again to sync.

For more information about error 40197, you can review the following article.
http://msdn.microsoft.com/en-us/library/windowsazure/ff394106.aspx

In addition, there is detail about data sync between SQL Azure database. See:
http://www.windowsazure.com/en-us/manage/services/sql-databases/getting-started-w-sql-data-sync/

Thanks,
Sof

Hi Well,

Can you provide your sync group id?

So we can check anything wrong in your sync group.

Thanks,

The sync group id is 373ba535-78a5-43f1-b3d5-499fe2c6f100_North Central US.

 Hi Well,

Could you check the index of the related table 'dbo.XXX', to see whether it is corrupted. Or you can try re-create the index of it. Please tell us if it works.

Regards,
Bowen

• Proposed as answer by Bowen Wan 2 hours 6 minutes ago

 Hi Well,

Could you check the index of the related table 'dbo.XXX', to see whether it is corrupted. Or you can try re-create the index of it. Please tell us if it works.

Regards,
Bowen

• Proposed as answer by Bowen Wan 2 hours 20 minutes ago

 Hi Well,

Could you check the index of the related table 'dbo.XXX', to see whether it is corrupted. Or you can try re-create the index of it. Please tell us if it works.

Regards,
Bowen

• Proposed as answer by Bowen Wan Monday, January 13, 2014 9:24 AM

 Hi Well,

Could you check the index of the related table 'dbo.XXX', to see whether it is corrupted. Or you can try re-create the index of it. Please tell us if it works.

Regards,
Bowen

• Proposed as answer by Bowen Wan Monday, January 13, 2014 9:24 AM

Thanks, Sofiya. I'll be try it.

Thanks Bowen, I'll try it.