Select Page

You try to create a backup or synchronize your Act! database and receive the Error „Cannot insert duplicate key row in object ’sys.syscommittab‘ with unique index ’si_xdes_id‘.“ 

 

This is a error associated with Microsoft SQL Server 2008 R2.

 

Step1: Apply SQL Server 2008 R2 Service Pack 2

You need to apply the Update on Act! server and all remote databases machines.
The Update can be found at the official Microsoft Homepage.
Follow the instructions from microsoft and install the Service Pack on all machines with Act! and SQL Server 2008 R2. Please begin at the database Server.

 

Step 2:Install „cumulative Update 8 for SQL Server 2008 R2 Service Pack 2“

You need to apply the Update on Act! server and all remote databases machines.
The Update can be found at the official Microsoft Homepage.
Follow the instructions from microsoft and install the Service Pack on all machines with Act! and SQL Server 2008 R2. Please begin at the database Server.

You can skip the Steps above if you already have SQL Server 2008 R2 Service Pack 2 and cumulative Update 8 for SQL Server 2008 R2 Service Pack 2 installed. Go on with Step 3 from now on if this is the Case.

 

Step 3: Run the batch file provided below on all databases

There are two different bat files. The first one is for SQL Express, the second one is for SQL Standard. Please make sure you chose the right one.

If you are not sure, which one to choose just go to the actdiag. There the needed information will be provided about your SQL Version. 

SQL 2008 R2 Express Fix.bat

SQL 2008 R2 Standard Fix.bat

Copy the batch file directly to C:\ and in not in any subfolders.

 

Double Click the back file to run it from this location. You will need to enter the name of the database which you are experiencing this error. 

Run the batch file several times until no rows are affected is displayed. It is recommended that you wait approximately 30 seconds before running the file a second or third time.

<