05-02-2013 02:07 PM
I am somewhat computer-challenged. I am using ACT! Pro 2012 and the back-up has stopped working. I get an error message that reads:
Cannot inset 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 error log...
BACKUP DATABASE is terminating abnormally.
I know that I can spend ~$100 and get someone at Sage to help me, but I figured maybe someone out there can give me some helpful information.
05-03-2013 06:16 AM - edited 05-03-2013 06:25 AM
You did not disclose your complete version/build of ACT!2012 Pro
ex: Sage ACT! Pro 2011 Version 126.96.36.199, Hot Fix 6
You may need to install the most current service pack/hot fixes?
Reference Download Center link
Are you trying to backup the Main database/server/publisher or a remote database?
but it sounds like you are trying to take a ACT! backup while syncing the database at same time?
No can do.
Take a look at ACT! / Tools / ACT! Scheduler
Hope this helps
Cheers - FSB
05-03-2013 07:11 AM
This is an error associated with Microsoft SQL Server. The best way to resolve this is to apply the Service Pack 1 for the SQL Server 2008 R2, then run a batch file that Sage created to fix the database. Details and instructions are in this Knowledgebase article:
Please note that if you are using a shared database, the procedures in the article must be done on all machines.
Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.