Symptom: You are attempting to create a backup, run maintenance, or synchronize on your Act! database, and receive the error: "Cannot insert duplicate key row in object 'sys.syscommittab' with unique index 'si_xdes_id'.".







This is an error associated with Microsoft® SQL Server® 2008 R2. You can resolve this issue by applying Cumulative Update 8 for SQL Server 2008 R2 Service Pack 2, then running the batch file provided in this article to fix the issue in your database(s). Please follow the exact steps below:Note: The information below is provided as a convenience. Swiftpage does not provide support for Microsoft products and downloads. For further assistance, please see the following KB article on Microsoft.com: 2682488.Step 1: If necessary, apply SQL Server 2008 R2 Service Pack 2 If you are not already running Service Pack 2 you will need to apply this update on the Act! server and all remote database machines with Act! and SQL Server 2008 R2 installed. 

    1. Download the update from the Microsoft download site: Microsoft® SQL Server® 2008 R2 Service Pack 2

        • Choose your version from the list (x64 for 64-bit, x86 for 32-bit, and IA64 for Itanium-based servers)



    1. Follow the download instructions from the site to install the Service Pack on all machines with Act! and SQL Server 2008 R2, starting with the database server.

    1. When the Service Pack has been applied to all machines, proceed to Step 2 below.


Step 2: Apply Cumulative Update 8 for SQL Server 2008 R2 Service Pack 2
You will need to apply this update on the Act! server and all remote database machines with Act! and SQL Server 2008 R2 installed. 


    1. Download CU8 from the Microsoft download site: Cumulative update package 8 for SQL Server 2008 R2 Service Pack 2

    1. Follow the download instructions from the site to install the hotfix on all machines with Act! and SQL Server 2008 R2, starting with the database server.

    1. When the hotfix has been applied to all machines, proceed to Step 3 below.


Step 3: Run the batch file on all databases
Run the batch file for your version of SQL Server found in the File Attachments section of this article to resolve the issue in the databases.
If you are using SQL Server 2008 R2 Express, use SQL2008R2_Express_BackupFix.bat If you are using SQL Server 2008 R2 Standard, use SQL2008R2_Standard_BackupFix.bat
Click HERE for instructions to determine your version of SQL Server.


Important Note for Remote Database Users: If you are experiencing this error during remote database synchronization, you will need to run the batch file on all remote databases and the main database. No users should attempt to sync until all databases have successfully run the batch file.

To download and run the file:

    1. Ensure you are signed in to Windows as an Administrator User.

    1. Ensure that the SQL Server (ACT7) service is running on your machine. Click HERE for instructions to verify if the service is running.

    1. Right-click on the appropriate batch file for your version of SQL Server from the File Attachments section below, and choose the Save option. Save it to your computer's Desktop.

    1. Close Act!

    1. Locate the file you downloaded on your Desktop. Right-click on it and select "Run As Administrator".

    1. When prompted, you will type in the name of the database in which you are experiencing the error. If you do not know the name of your database, then open Act! in look in the upper left corner of the screen - the name of your database will be after the Ac! product name.

    1. After you type in the name of your database, press ENTER on your keyboard to run the fix
      Important: Run the .bat file multiple times, until 0 rows affected is displayed. Wait approximately 30 seconds before running the file again.

    1. Reopen Act! and test the function you were receiving the error with.


If you receive an error when running the batch file, please see the Related Information below.




Related InformationNote: The information below only applies if you receive an error when applying the batch file mentioned above. If you have not received an error when applying the batch file, then this information does not apply. If you receive an error when running the batch file, you may be able to resolve using the following steps:

Option 1: Disable User Account Control (UAC) in Windows

    1. For instructions on how to disable UAC, follow the steps in the article below that applies to your computer's operating system:
      How to Disable User Account Control (UAC) in Windows Vista® Answer ID: 20220

      How to Change or Disable User Account Control (UAC) in Windows® 7 & Windows Server® 2008 Answer ID: 25665

    1. Double-click on the .bat file to run it.


Option 2: Change Location of .Bat File

    1. Copy the batch file you downloaded from this article.

    1. Open Windows® Explorer and browse to one of the following directories, depending on your operating system and SQL Server installation:
      SQL Server (64-bit version) installed on a 64-bit operating system: C:\Program Files\Microsoft SQL Server\100\Tools\Binn
      SQL Server (32-bit version) installed on a 64-bit operating system: C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn
      SQL Server (32-bit version) installed on a 32-bit operating system: C:\Program Files\Microsoft SQL Server\100\Tools\Binn

    1. Paste the batch file in the "Binn" folder.

    1. Double-click the batch file to run it from this location. When prompted, you will type in the name of the database in which you are experiencing the error. If you do not know the name of your database, then open Act! in look in the upper left corner of the screen - the name of your database will be after the Act! product name.


Option 3: Service SQL Server Browser Not Running

    1. Open Windows Services

    1. Locate SQL Server Browser

    1. Right click service; select Start

    1. Attempt to run bat file


Option 4 - Microsoft SQL Server 2008 Feature Pack If the above steps still do not allow you to run the batch without error, then you may be able to resolve this by downloading the Microsoft SQL Server 2008 R2 Command Line Utilities package, which is listed on the Microsoft SQL Server 2008 Feature Pack web page. Run the batch file again after downloading this utility pack.
In addition, please see the following Knowledgebase article for more information:
Title: Error: "Msg 18456, level 14, state 1, server Server\Act7, line1…Login Failed for user domain\username” While Running a .bat File Answer ID: 33620   



File Attachments






.

2013-11-13 11:42:24
 
Comments List