none
Unable to SYNC Table with follow error

    Question

  • Hi There,

    I really need help on this, i first provision 2 tables and successful and i wrote a program to pump data and try sync to server and here is my result.

    1. Pump 10 records - Successful

    2. Delete previous 10 records and Pump 100 records - Successful

    2. Delete previous 100 records and Pump 20 records - Failed

    And this is the error message from the sync tracer i get and found no solution on google 

    Exception i get is : The argument tombstoneKey is improperly formatted. Refer to the documentation for the correct format.

    Anyone help me on this? As i really have no idea what is going wrong with the data. Every table consist of 1 uniqueidentifier field and i believe my data is unique enough.

    Error from Sync Tracer

    /2013 04:41:16:681, Committing transaction
    INFO   , BBSync.vshost, 12, 08/21/2013 04:41:16:685,    EndSession() called on Provider SqlSyncProvider, Microsoft.Synchronization.Data.SqlServer, Version=3.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
    INFO   , BBSync.vshost, 12, 08/21/2013 04:41:16:686,    EndSession() called on Provider SqlCeSyncProvider, Microsoft.Synchronization.Data.SqlServerCe, Version=3.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
    INFO   , BBSync.vshost, 12, 08/21/2013 04:41:16:688,    BeginSession() called on Provider SqlCeSyncProvider, Microsoft.Synchronization.Data.SqlServerCe, Version=3.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
    INFO   , BBSync.vshost, 12, 08/21/2013 04:41:16:762,    BeginSession() called on Provider SqlSyncProvider, Microsoft.Synchronization.Data.SqlServer, Version=3.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
    ERROR  , BBSync.vshost, 12, 08/21/2013 04:41:16:933, Caught exception while getting changes: System.ArgumentException: The argument tombstoneKey is improperly formatted. Refer to the documentation for the correct format.
       at System.Data.SqlServerCe.SqlCeChangeTracking.UnpackTombstoneKey(String tableName, Byte[] tombstoneKey)
       at Microsoft.Synchronization.Data.SqlServerCe.SqlCeSyncUtil.PopulateTrackingTableFromTombstones(SqlCeConnection connection, SqlCeTransaction trans, DbSyncAdapterCollection adapters, SqlCeSyncScopeHandler scopeHandler, Boolean upgradeLogic)
       at Microsoft.Synchronization.Data.SqlServerCe.SqlCeSyncProvider.BeforeChangeEnumeration()
       at Microsoft.Synchronization.Data.RelationalSyncProvider.GetChanges(DbSyncScopeMetadata scopeMetadata, DbSyncSession DbSyncSession, UInt32 memoryBatchSize)
    ERROR  , BBSync.vshost, 12, 08/21/2013 04:41:16:936, Disposing of transaction
    INFO   , BBSync.vshost, 12, 08/21/2013 04:41:16:938,    EndSession() called on Provider SqlSyncProvider, Microsoft.Synchronization.Data.SqlServer, Version=3.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
    INFO   , BBSync.vshost, 12, 08/21/2013 04:41:16:939,    EndSession() called on Provider SqlCeSyncProvider, Microsoft.Synchronization.Data.SqlServerCe, Version=3.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91


    ChinCahi

    Wednesday, August 21, 2013 5:20 AM