Error: "Cannot insert duplicate key row in object 'sys.syscommittab' with unique index 'si_xdes_id'... error 2601" when attempting to back up, copy, repair, create a remote, or synchronize an Act! database

Option 1 - Resolve using Act! Diagnostics (Microsoft SQL Server Express only)

Important Note: If this error is occurring on a database which is part of a remote synchronization environment, these steps need to be performed on the machine where the main database resides, as well as all machines that contain remote databases that synchronize back to the main database. The version of SQL Server should be verified on each machine to make sure the appropriate steps are followed

Act! users who are using Microsoft SQL Server Express can use Act! Diagnostics version 17.1 or later to automatically download and apply the Microsoft SQL Server 2008 R2 Service Pack 1 and CU 6, as well as automatically run a command against the affected database to repair it.

1. Close Act! and any other applications which may use SQL Server, if applicable
2. Download and save Act_Diagonstics_v17_2.exe from the File Attachments section at the bottom of this article
3. Open the Act! Diagnostics v17.2, and click OK on the disclaimer
4. Click Databases > Database list
5. Select and highlight the affected database, then click Actions > Syscommittab Repair
6. When the warning appears to notify you all applications that use SQLServer must be closed, click Yes to begin the update and repair process
7. After the status bar and command windows close and Act! Diagnostics reopens, close Act! diagnostics
8. Launch Act! and test using the function which was producing the error

Note: If you have multiple affected databases, repeat these steps for each database to run the command against each affected database


Option 2: Applying Service Pack 3 to Microsoft SQL Server 2008 R2

Important Note: If this error is occurring on a database which is part of a remote synchronization environment, these steps need to be performed on the machine where the main database resides, as well as all machines that contain remote databases that synchronize back to the main database.

Act! users who are using Microsoft SQL Server Standard, or who were unsuccessful in resolving the issue through using Act! diagnostics commands must download and install Microsoft SQL Server 2008 R2 Service Pack 3, then run a batch file. See below for steps:

1. Close Act!
2. Download and install Microsoft SQL Server 2008 R2 Service Pack 3. For information on downloading and installing this service pack, refer to the following Microsoft documentation:
   
   SQL Server 2008 R2 Service Pack 3 release information
   
   
3. Depending on whether you are using SQL Server Standard or Express, download one of the following files from the File Attachments section of this article at the bottom of the page:
   
   • Microsoft SQL Server Standard: SQL_Standard_BackupFix.bat
   • Microsoft SQL Server Express: SQL_Express_BackupFix.bat
4. Right-click the downloaded file and select Run as administrator
   
   Note: If you are using Windows XP/Server 2003, simply double click the file to run it.
   
   
5. When prompted, type the name of the database which is experiencing the error, then press Enter
6. Repeat steps 4 and 5 until 0 rows affected displays, waiting approximately 30 seconds between each time the file is run
7. Open Act! and test the function which was producing the error

Note: If you have multiple affected databases, repeat steps 3 - 6 for each database to run the command against each affected database.

Click here only if you receive an error when trying to run the batch file

Important Note: If this error is occurring on a database which is part of a remote synchronization environment, these steps need to be performed on the machine where the main database resides, as well as all machines that contain remote databases that synchronize back to the main database. The version of SQL Server should be verified on each machine to make sure the appropriate steps are followed

In order to resolve this issue, it is necessary to make sure that your Microsoft SQL Server installation has the latest update applied to it. Once applied, it will be necessary to run one the appropriate batch file. See the steps below:

1. Close Act!
2. Download and install the update that applies to the version of Microsoft SQL Server you are using with Act!. To find the appropriate download link, refer to the following Microsoft documentation:
   
   FIX: Backup operation fails in a SQL Server database after you enable change tracking
   
   
3. Depending on whether you are using SQL Server Standard or Express, download one of the following files from the File Attachments section of this article at the bottom of the page:
   
   • Microsoft SQL Server Standard: SQL_Standard_BackupFix.bat
   • Microsoft SQL Server Express: SQL_Express_BackupFix.bat
   
   
4. Right-click the downloaded file and select Run as administrator
5. When prompted, type the name of the database which is experiencing the error, then press Enter
6. Repeat steps 4 and 5 until 0 rows affected displays, waiting approximately 30 seconds between each time the file is run
7. Open Act! and test the function which was producing the error

Note: If you have multiple affected databases, repeat steps 3 - 6 for each database to run the command against each affected database


Click here only if you receive an error when trying to run the batch file