UploadChangesFailed always > 0

Feb 16, 2010 at 2:13 AM

Hi

We've been trying to get UploadOnly working using Synccomm on a SQL Server CE Device DB to a SQL Server 2008 Service with Change Tracking.  The first set of data from the device goes up to the database, but the UploadChangesFailed is always equal to the number of rows sent up.  Then, all edits after that fail to upload.

SyncStatistics statistics = agent.Synchronize();

if (statistics.UploadChangesFailed > 0)

 

On the server side, we handle the following, and the event handler is called twice for each record, first with ClientInsertServerInsert, then with ErrorsOccurred, and the rows fail to update in the Server database.  We even tried ApplyAction.RetyrWithForceWrite

        private void RemoteProviderFr8Scanner_ApplyChangeFailed(object sender, ApplyChangeFailedEventArgs e)
        {
            if (e == null || e.Conflict == null) return;

            switch (e.Conflict.ConflictType)
            {
                case ConflictType.ErrorsOccurred:
                    break;
                case ConflictType.ClientInsertServerInsert:
                    e.Action = ApplyAction.Continue;
                    break;
                default:
                    break;
            }
        }

If I try to set the mode to bidirectional, I get an error trying to access the anchor.
Any ideas?
Thanks
Feb 16, 2010 at 2:46 AM

BTW, the Error returned on the second pass is  "SQL Server change tracking has cleaned up tracking information for table 'dbo.RawScan'. To recover from this error, the client must reinitialize its local database and try to synchronize again.".  We've reset the emulator and everything.  No luck.