11-28-2011 02:00 PM
I am now getting an error message "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 9 due to error 2601. Check error log for more information. The statement has been terminated." I found KB article 28141, and thought that batch file would fix it. Followed directions, and same error message persists. Anyone know how to fix this? Prior to this, network synch was working. Thanks, Carl
11-28-2011 10:15 PM
02-19-2012 04:37 PM
Hi, we have the 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 9 due to error 2601. and we have the very latest verion of ACT, would anyone have any ideas of how to fix this, thanks.
02-19-2012 05:32 PM
If you are getting any sync errors, please check your version of ACT!. If it is not 2012 SP1, please update both
your computer and all other computers with ACT! to that version.
Then try syncing after that update. Does it still fail?
02-19-2012 06:16 PM - edited 02-19-2012 07:30 PM
Thanks for the prompt response both machines have the ACTPro2012SP1_AU_Update.exe installed, and the issue still exists, is this likely to have anything to do with the latest updates from Windows, thanks
02-20-2012 03:47 PM
Have you looked at this Knowledge base Article Error: ""Cannot insert duplicate key row in object 'sys.syscommittab' with unique index 'si_xdes_id'...
Let me know how you go
02-20-2012 04:02 PM - edited 02-20-2012 04:05 PM
Thanks for your help with this, I have now resolved the problem with assistance from Judy Bond our trusty New Zealand Sage ACT specialist who went above and beyond the call of duty, would recomend to others.
Judi Bond CA
ACT! Certified Consultant
A2Z Software Ltd
Sage Business Partner
Accounting Software Consultant
PO Box 71082, Rosebank, Auckland 1348
Ph: 64-9-820 6080
Fax: 64-9-820 6081
Mob: 027 478-4476
Web : www.a2zdata.co.nz
ACT!® - Make Contact. Build Relationships. Get Results.
04-07-2012 08:43 PM
I have referenced the aforementioned knowledgebase article. I have completed all of the steps suggested in all three options. I have done this on both the server and the remote machine and I get the same error message. I welcome any suggestions.
David C. Noe
08-21-2012 04:41 AM
Has anyone successfully solved this issue?
Updated to SP1 and tried all the solutions in the support article, problem still persists.
ACT has been nothin but trouble for my company...