12-26-2012 07:10 AM
ACT Pro 2012 V22.214.171.124 on Windows 7 Home with all the windows updates applied. 2 user trying to sync gets this error:
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."
I've downloaded the ACTdiagutility per another KB and ran the syscommit repair that says it succedded to no avail. I've ran it multiple times while everytime gives me the same "succedded". I can't create a new remote database, I can check repair the database, and I can't do the database rebuild - rebuild sync objects - I get a simlar error about cannot insert duplicate key row.
12-26-2012 08:48 AM
Please list the KB article you applied, but assuming we are thinking about the same article. you need to run the patch on the maindatabase and eath of the remotes.
12-26-2012 03:40 PM