Category: Offline Sync Service
Offline Sync service fails to synchronize data with error "Bulk command BulkInsertCommand failed with the following exception. Rows will be retried during single apply. System.Data.SqlClient.SqlException (0x80131904): String or binary data would be truncated."
Sometimes when Offline Sync Service is syncing a large table (with much data), it’s interesting to check the status of sync - to validate how many records have been already inserted. For this we can execute Uncommitted read in SQL Management Studio.