Community
Showing results for 
Search instead for 
Do you mean 
Reply

Sync Error

Copper Contributor
Posts: 36
Country: United States

Sync Error

ACT Pro 2012 V14.1.108.0 on Windows 7 Home with all the windows updates applied.  2 user trying to sync gets this error:

Synchronization has failed. Cannot insert 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

Errorlog for more information

The statement has been terminated. Contact your administrator for assistance."

 

I've downloaded the ACTdiagutility per another KB and ran the syscommit repair that says it succedded to no avail.  I've ran it multiple times while everytime gives me the same "succedded".  I can't create a new remote database, I can check repair the database, and I can't do the database rebuild - rebuild sync objects - I get a simlar error about cannot insert duplicate key row.

 

ANy ideas?

Silver Contributor
Posts: 1,813
Country: USA

Re: Sync Error

Please list the KB article you applied, but assuming we are thinking about the same article. you need to run the patch on the maindatabase and eath of the remotes.

Test Drive Act! and Quickbooks over Citrix http://GoTryAct.com

Jon Klubnik| ActTrainer.com
(866)710 4228

ACT! Certified Consultant / ACT! Premier Trainer / ACT! Hosting Provider

New Member
Posts: 5
Country: United States

Re: Sync Error

I'm haveing the exact same issue. It started this AM. My two remotes can't sync. Is this due to the recent Windows update?

New Member
Posts: 5
Country: United States

Re: Sync Error

I downloaded and installed ACT! Diagnostics_v15.0.288.exe on all 3 machines, followed the instructions but still no sync

Copper Contributor
Posts: 36
Country: United States

Re: Sync Error

KB 28141 - ran on all multiple times still not working.

Silver Contributor
Posts: 1,813
Country: USA

Re: Sync Error

Did the batch file finish without error?

Test Drive Act! and Quickbooks over Citrix http://GoTryAct.com

Jon Klubnik| ActTrainer.com
(866)710 4228

ACT! Certified Consultant / ACT! Premier Trainer / ACT! Hosting Provider

Copper Contributor
Posts: 36
Country: United States

Re: Sync Error

Yes on both systems it completed without error.