Community
Showing results for 
Search instead for 
Do you mean 
Reply

error in creating a duplicate data base

Highlighted
Astute Commentator
Posts: 17
Country: USA

error in creating a duplicate data base

on creating a duplicate copy of a shared database with other name Act popup an error " The database failed to copy due to the following reason: Cannot insert duplicate key row in object 'sys.syscommittab'with unique index'si_xdes_id'/The duplicate key vlaue is (593518). Failed to flush the commit table to disk in dbid 9 due to error 2601.check the errorlog for more information. Backup Database is terminating abnormally. Cannot open backup device 'xyz. operating system error 2( The system cannot find the file specified.) Restoring Database is terminating abnormally. The statement has been terminated.

 

Highlighted
Silver Contributor
Posts: 2,015
Country: United_Kingdom

Re: error in creating a duplicate data base

You don't say which version of ACT you are running but I expect you will find it is on SQL 2008

 

This is a well know problem and is caused by a defect in SQL 2008

 

To fix run a repair from the utility called ACTDIAG which you will find in the ACT program folder or just type ACTDIAG at the start button. It must be run as administrator to repair the syscom error so right click ACTDIAG and select the run as administrator option. If it is an old version I advise downloading the latest version, see below.

 

Download latest ACTDIAG from http://kb.act.com/app/answers/detail/a_id/38321/~/what-is-the-most-recent-version-of-the-act%21-dia...

 

You can also download the ACTDIAG users guide from http://kb.act.com/ci/fattach/get/34464/0/filename/ActDiag+User%27s+Guide.pdf

 

Make sure ACT is not running - Start ACTDIAG as administrator

 

Once ACT DIAG is running

 

Click on Databases now select Database names list (2nd option as the syscom error may not let you use option 1)

 

Find your database and right click, now select Syscommittab repair.

 

When finished try running ACT again and see if it will let you copy the database.

 

 

 

 

Highlighted
Nickel Super Contributor
Posts: 480
Country: United_Kingdom

Re: error in creating a duplicate data base

There is also a KB about this http://kb.act.com/app/answers/detail/a_id/28141 you can run the bat file for the version of SQL being used on the server at the bottom of the page once downloaded. Make sure you right mouse click and run as administrator. 

 

Just in case you can any issues when running the Syscommittab repair in actdiag