Data Sync - SqlError Number:4902, Message: SQL error with code 4902

Question

Data Sync - SqlError Number:4902, Message: SQL error with code 4902

NityaVishwanathan-6321 230

Hello Team, I am encountering this error.What could be the reason Sync failed with the exception "An unexpected error occurred when applying batch file sync_**.batch. See the inner exception for more details.Inner exception: Failed to execute the command 'BulkInsertCommand' for table 'dbo.tableyy'; the transaction was rolled back. Ensure that the command syntax is correct.Inner exception:Error Code: -2146232060 - SqlError Number:4902, Message: SQL error with code 4902

Oury Ba-MSFT 21,156 Reputation points Microsoft Employee Moderator

2024-02-05T21:58:50.1633333+00:00

@Nitya V
Thank you for reaching out. Looks like the inner exception share above points to a failure in executing the bulkInsertCommand for table name dbo.tableyy. Can you check column datatypes. Compare them between source and destination. Remember datasync does not handle schema changes. Any change in source table need to be manually applied to destination table. Each table in a sync group must have a primary key. SQL Data Sync can't sync a table that doesn't have a primary key. PK is needed on every table for sync to happen and that was it. Please check this doc for more details Best Practices Regards, Oury
NityaVishwanathan-6321 230 Reputation points

2024-02-06T08:49:50.9866667+00:00

This table was syncing previously suddenly it started giving this error .No changes in schema
Oury Ba-MSFT 21,156 Reputation points Microsoft Employee Moderator

2024-02-09T00:19:11.2166667+00:00

@Nitya V I would suggest opening a support ticket so we can deep further into the root cause of the issue. Regards, Oury