08-27-2012 12:50 PM
I have recently started having trouble syncing remotely. None of the other remote users are having any problems so I think it is with my laptop.
I get through to the end of the sync but then the following error messsage appears:
"Synchronization has failed. Cannot insert duplicate key row in object
‘sys.syscommittab’ with unique index ‘si_xdes_id’.
Failed to flush the commit table to disk in dbid 7 due to error 2601. Check the
Errorlog for more information
The statement has been terminated. Contact your administrator for assistance."
Any help would be great.
10-03-2012 03:15 AM
Same error here.
Tried KB 28141 but no luck.
Ended up recreating remote, and everything worked fine for a couple of weeks.
Error is back again.
10-25-2012 09:36 AM
Have also been having this problem recently over a number of sites. It looks like after a recent MS SQL update that things started to play up. It seems to behave like a flu virus passing from 1 database to another via sync.
I have tried the various solutions and now strongly promote running the scrip on all machines with a database and the server making sure no one syncs while this is done. )Using the ACTDIAG option does not let you know if it has cleared the error even thought it reports success at the end.)
The script must be run until it come up with a (0) which I found meant 3 or 4 times.
Not in the article but essential is always right click on the script and run as administrator