Community
Showing results for 
Search instead for 
Do you mean 
Reply

RDB Sync Broken - Recover changed RDB data to master?

Copper Contributor
Posts: 50
Country: USA

RDB Sync Broken - Recover changed RDB data to master?

Looking for suggestions to recover changes trapped in a remote 2013 Premium HF3 database after the sync failed.

 

"Message: Synchronization has failed. Cannot insert duplicate key row in object 'sys.syscommittab' with unique index 'si_xdes_id'. The duplicate key value is (222664). Failed to flush the commit table to disk in dbid 7 due to error 2601."

 

The remote was using the scheduler to sync data for a couple of states. 3 other RDB users are synching OK. Would have been nice to have some "in your face" indication of sync failure with the sync process was on autopilot.

 

My thought is to delete the affected states in the master database, move a copy of the RDB to the server and then import.

Any pitfalls in this approach?

 

Thank you!

Kit Leithiser
CIM Soiftware LLC
828.322.8155
kit@leithiser.com
Copper Contributor
Posts: 50
Country: USA

Re: RDB Sync Broken - Recover changed RDB data to master?

Shoot, Ready, Aim!

 

Found http://kb.sagesoftwareonline.com/app/answers/detail/a_id/28141 which describes the problem is caused by an error associated with Microsoft® SQL Server® 2008 R2.

 

Solution: Apply Service Pack 1 for SQL Server 2008 R2 & then run the batch file provided.

 

Do I glean from this that all 2013 installs that may sync should be followed up with SQL SP1 to prevent this error?

 

Thank you!

 

 

Kit Leithiser
CIM Soiftware LLC
828.322.8155
kit@leithiser.com
Silver Contributor
Posts: 1,813
Country: USA

Re: RDB Sync Broken - Recover changed RDB data to master?

You need to follow that procedures against all databases before syncing again.

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