It seems to me is a permissions issue. Please make sure you have provided as a minimum the permissions specified on this documentation.
Data Sync failed with the exception "An unexpected error occurred when applying batch file sync_**.batch. "
Hi I am receiving the following error on almost all the tables in a groups .What is the cause and fix 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.table1'; the transaction was rolled back. Ensure that the command syntax is correct.Inner exception: SqlException ID: 55169e17-01a9-4e1c-8310-1b8ae85f4d90, Error Code: -2146232060 - SqlError Number:229, Message: SQL error with code 229