Community
Showing results for 
Search instead for 
Do you mean 
Reply

Act! Premium 2013 BackUp Error

New Member
Posts: 4
Country: USA

Act! Premium 2013 BackUp Error

Hi all,

 

PLEASE HELP

 

I'm receiving this error when trying to do complete a back up on a 2008 Server R2 Standard SP1 on Act! Premium 16.2.14.0

 

The following error occurred during backup.  The backup was cancelled.

 

Cannot insert duplicate key row in object 'sys.syscommittab' with unique index 'si_xdes_id'.  The duplicate key value is (5820541).  Failed to flush the commit table to disk in dbid 9 due to error 2601.

Check the error log for more information.

BACKUP DATABASE is terminating abnormally.

PRC_MAINT_BACKUPDB: ERROR EXECUTING DATABASE BACKUP STATEMENT

The statement has been terminated.

 

Any idea? Please Help!

Nickel Elite Contributor
Posts: 531
Country: USA

Re: Act! Premium 2013 BackUp Error

[ Edited ]

You can resolve this issue following the instructions below



This is an error associated with Microsoft® SQL Server® 2008 R2. You can resolve this issue by applying Cumulative Update 6 (or later) for SQL Server 2008 R2 Service Pack 1, then running the batch file provided in this article to fix the issue in your database(s). Please close Act! and 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.

Option 1: Download and run the DBFixer available here: http://dlm.act.origin.swiftpage.com/3271/syscommittab_dbfixersilent.exe. This will update your SQL Server 2008 R2 to SP1 CU6 and attempt to fix any database errors caused by this issue. Depending on computer speed, database size, amount of errors, and other factors this might take a long time to finish running.

Option 2: As a temporary fix, run the attached 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.
  2. Ensure that the SQL Server (ACT7) service is running on your machine. Click HERE for instructions to verify if the service is running.

  3. 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.
  4. Close Act!
  5. Locate the file you downloaded on your Desktop. Right-click on it and select "Run As Administrator".
  6. 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.
  7. 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.

  8. 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 Information

Note: The information below only applies if you receive an error when applying either fix mentioned above. If you have not received an error when applying the batch file or DBFixer, 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
  2. 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.
  2. 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

  3. Paste the batch file in the "Binn" folder.
  4. 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
  2. Locate SQL Server Browser
  3. Right click service; select Start
  4. 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.

 

Michael Kadlub
Act! Support Manager
Keystroke Quality Computing Inc.
800-857-0558, x.310
MichaelK@kqc.ca
www.keystroke.ca