09-09-2011 06:26 AM
before i down load the license version of 2012 premium act, it advised me to backup the data base. when i try to back up my data base i receive an error message. error message reads as follows.
cannot insert key row in object 'sys.syscommittab' with unique index'si_xdes_id'.
failed to flush the commit table to disk in dbid 21 due error 2601.
check the errorlog for more information.
PRC_MAINT_BACKUPDB:ERROR EXECUTING DATABASE BACKUP STATEMENT
the statement has been terminated
09-10-2011 04:37 PM
The error is occurring due to a bug in Microsoft SQL Server 2008 (R2). Microsoft has claimed to have fixed this in SP1 of SQL 2008 but unfortunately we were not able to include this as part of the release because it wasn't formally released until late July when product development for ACT! had completed. The fix in SP1 would prevent this problem from occurring but it isn't corrective once a database is in this state. However, we do have a solution for you.
First go ahead uninstall the beta version via add/remove programs. Please do not uninstall SQL. Install the gold version of ACT!. But after install DO NOT start ACT! instead do the following:
Go to C:\Program Files\ACT\Act for Windows
In the folder there are two files that will correct your problem (The reason I tell you to install the gold version is these files did not exist in the beta)
One is for SQL Express, the other is for all other versions of SQL Server. I'm assuming that you just installed ACT! and let the installer do it's thing and you are not an admin supporting a 30+ installation and installed SQL Server Standard. That being the case you will use the Express_BackupFix.bat
After you locate the bat file for your version, perform these steps
To prevent the problem from occurring again you can install SP1 of SQL 2008 through automatic windows updates or you can get a copy here It’s available at: http://www.microsoft.com/download/en/details.aspx?id=26727
Sorry for the inconvenience.
09-12-2011 09:24 AM
I am having the same problem. I did as suggested and I am still getting the same messege. Please help, I am unable to back my database.
09-12-2011 03:06 PM - edited 09-12-2011 03:06 PM
Please see KB Article 28141 for instructions and batch files you can run for this error.
Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.
09-20-2011 06:53 AM
I am having a similar problem, but it happens when I try and sync.it happens on the remote database towards the end when it is checking for errors. Do i use the same steps you suggested here?
05-23-2012 09:19 PM
Before I did my "UPGRADE" I could do ACT 2012 backups. Now that I have upgraded and kept current I am having problems. Ugh! Will call ACT next week and see what I should do. If I uninstall ACT won't I lose my data?
05-24-2012 07:28 AM
What is your error message when attempting a backup? Did you try the steps in KB Article 28141?
The uninstall will not affect the data in your database. The database is made up of an ADF, ALF, and PAD file, along with the 'databasename - database files' folder.
For safety, you can manually copy your database files/folder. Use the following instructions to stop the SQL service and then copy the database files:
- close Sage ACT!
- click Windows Start button
- XP > select Run. Vista/Win 7 > use Search field
- enter command 'services.msc' > press Enter key
- locate 'SQL Server (ACT7)' > right click > select Stop
- copy/paste the database files/folder to safe location
- start SQL service
- open database