Community
Showing results for 
Search instead for 
Do you mean 
Reply

ACT! back-up failure

New Member
Posts: 3
Country: USA

ACT! back-up failure

I am somewhat computer-challenged. I am using ACT! Pro 2012 and the back-up has stopped working. I get an error message that reads:

 

Cannot inset duplicate key row in object 'sys.syscommittab' with unique index 'si_xdes_id'.

Failed to flush the commit table to disk in dbid 7 due to error 2601.

Check the error log...

BACKUP DATABASE is terminating abnormally.

etc.

 

I know that I can spend ~$100 and get someone at Sage  to help me, but I figured maybe someone out there can give me some helpful information.

 

Any ideas?

 

Zissel

Nickel Elite Contributor
Posts: 934
Country: USA

Re: ACT! back-up failure

[ Edited ]

Hello Zissel,

 

You did not disclose your complete version/build of ACT!2012 Pro

  ex: Sage ACT! Pro 2011 Version 13.1.111.0, Hot Fix 6

 

You may need to install the most current service pack/hot fixes?

Reference Download Center link

http://download.act.com/support/downloads/Sage-ACT-Pro-2012-Product-Downloads.html 

 

Are you trying to backup the Main database/server/publisher  or a remote database?

 

 but it sounds like you are trying to take a ACT! backup while syncing the database at same time?

   No can do.

 

Take a look at ACT! / Tools / ACT! Scheduler

 

Hope this helps

Reference KB article http://kb.sagesoftwareonline.com/app/answers/detail/a_id/28141/kw/Cannot%20inset%20duplicate%20key%2...

 

Cheers - FSB

 

Bill Williams - Owner/Consultant/Trainer at Fill Staff "ACT! FOR RECRUITERS"
Manage Your ACT! Backups http://fillstaff.com/backupfolderspro.html - FREE
BIG ACT! LAYOUTS for Larger Monitors www.bigactlayouts.com
Protect your Files & Folders with Folder Lock Pro by New Software http://download.cnet.com/Folder-Lock/3000-2092_4-10063343.html
Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: ACT! back-up failure

Hello Zissel,

This is an error associated with Microsoft SQL Server. The best way to resolve this is to apply the Service Pack 1 for the SQL Server 2008 R2, then run a batch file that Sage created to fix the database. Details and instructions are in this Knowledgebase article:

http://kb.Sagesoftwareonline.com/cgi-bin/Sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=2814...

 

Please note that if you are using a shared database, the procedures in the article must be done on all machines.

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.