Error in BulkInsertCommand in Sync Framework 2.1

Question

In some cases, I get the following error when trying to synchronize with SQL Express on SQL Server using Sync Framework 2.1. Once the client receives this error, they must reinitialize the scope. There can be nothing wrong with syntax, such as an error state, since it does not cause problems for long periods of time (with inserts). Any thoughts?

11:18:21 AM Failed to execute the "BulkInsertCommand" command for table "XXX"; The transaction was rejected. Verify that the command syntax is correct. 11:18:21 Microsoft.Synchronization 11:18:21 AM at Microsoft.Synchronization.Data.ChangeHandlerBase.CheckZombieTransaction (String commandName, String table, Exception ex)

From the trace log:

WARNING, OfflineAgentMonitor.vshost, 13/05/2011 11:16:17:224, Bulk command BulkUpdateCommand failed with the following exception. Lines will be repeated during a single application. System.Data.SqlClient.SqlException (0x80131904): attempt to pass a table parameter with 19 columns (columns) in which 20 columns are required for the corresponding table type.

Answer 1

try turning on Synchronize Fx tracing and see if Sync Fx synchronizes the original exception. if I remember correctly, the exception usually occurs when the db connection is lost. You should be able to repeat the synchronization, but without reconfiguring the area.

Answer 2

This happened to me, synchronizing between two Azure SQL databases. The original reason was that the slave database was growing more than if it was installed. I increased the size, but it was nice 20 minutes before the synchronization stopped giving an error