Error: ""Cannot insert duplicate key row in object
'sys.syscommittab' with unique index 'si_xdes_id'" When Attempting to Backup or Repair a Sage ACT! Database
You are attempting to create a backup or run maintenance on your Sage ACT! database, and receive the error:
""Cannot insert duplicate key row in object 'sys.syscommittab' with unique index 'si_xdes_id'".
This problem seems limited to ACT! 2012 and not with earlier versions. Some additional erros for backup are covered in this article as well.
This is an error associated with Microsoft® SQL Server® 2008 R2. This issue can be resolved by running one of
the batch files found in the File Attachments section near the bottom of this article.
- If you are using SQL Server 2008 R2 Express (The default ACT! installation, use SQL2008R2_Express_BackupFix.bat
- If you have installed SQL Server 2008 R2 Standard, use SQL2008R2_Standard_BackupFix.bat
To run this file: Click on the appropriate file below, and choose the Save option. Save it to your desktop. If your database is on a server you should save the file to the Server.
Step 2. Close Sage ACT!
Step 3. Locate the file you downloaded and double-click on it to run it.
After the file runs, click your Windows® Start button, and on the Start menu either click Run or go to the Search box at the bottom of the Start menu. Type in services.msc.
Step 5. In the list of services, locate SQL Server (ACT7).
Step 6. Right-click on this service and select Restart. Close the services window.
Step 7. Reopen Sage ACT! and make a backup of your database to test.
Step 6. Provided this was successful you can retest