Community
Showing results for 
Search instead for 
Do you mean 
Reply

Remote Database Synchronization Failure

Accepted Solution Solved
New Member
Posts: 11
Country: USA
Accepted Solution

Remote Database Synchronization Failure

I am trying to sync my remote database, but get an error that reads:

Synchronization has failed.  Cannot insert duplicate key row in object 'sys.syscommittab' with unique index 'si_sdes_id'.  The duplicate key value is (448519).

Failed to flush the commit table to disk in dbid7 due to error 2601.  Check the errorlog for more information.

The statement has been terminated.

@cSQLJOIN - IN TYPENUM IS ^

FIRST STATE @ cSQLJOIN IS   INNER JOIN dbo.CTL_SYNCROW_EXCEPTION SRE ON A.CONTACTID1 - SRE.ROW1D1 AND SRE.SYNCDBMAPID= @nSYNCDBMAPIE AND SRE.TABLEUID = @nENTITY_TLUID

     INNER JOIN dbo.CTL_SYNCDBMAP_SESSIONROW R1 ON R1.CONTACTID - A.CONTACTID1 AND R1.SYNCDBMAPID - @nSYNCDBMAPIE AND R1.SESSIONID = @nNEXT_SESSIONID

      INNER JOIN dbo.CTL_SYNCDBMAP_SESSIONROW R2 ON R2.CONTACTID - A.CONTACTID2 AND R2.SYNCDBMAPID - @nSYNCDBMAPIE AND R2.SESSIONID = @nNEXT_SESSIONID

Contact your administrator for assistance.

 

Since I am my 'administrator', I need a little guidance here. 

Any thoughts?

The data seems to be syncing to the main system.  It's only when it's in the checking for errors step that it gets about halfway through and I get the message.  This has happened a couple of times now and I'm concerned that this is just the tip of the iceberg on a problem.

    


Accepted Solutions
Solution
Accepted by topic author MartyinPlano
‎09-25-2015 03:20 AM
Platinum Super Contributor
Posts: 5,275
Country: USA

Re: Remote Database Synchronization Failure

The following article contains instructions for addressing this issue: KB Article 28141

Greg Martin
Sage

View solution in original post


All Replies
Solution
Accepted by topic author MartyinPlano
‎09-25-2015 03:20 AM
Platinum Super Contributor
Posts: 5,275
Country: USA

Re: Remote Database Synchronization Failure

The following article contains instructions for addressing this issue: KB Article 28141

Greg Martin
Sage
Copper Contributor
Posts: 58
Country: USA

Re: Remote Database Synchronization Failure

I'm having the exact same problem and tried to click on your link to the KB28141 article and it doesn't seem to take me anywhere on the ACT site and I can't seem to search on it. Has this article been updated?

Copper Elite Contributor
Posts: 144
Country: Australia

Re: Remote Database Synchronization Failure

[ Edited ]

Hi Jered,

 

The link is for the sage KBase for Act! which is now defunct.

 

instead you can find the same article at kb.swiftpage.com by searching for the Article ID number 28141

 

here is the link:  http://kb.swiftpage.com/app/answers/detail/a_id/28141

 

 

Kind Regards

 

Jared Dalrymple | Technical Consultant | P:+61 7 3423 3551
jared@evolutionmarketing.com.au | Evolution Marketing Services


Copper Contributor
Posts: 58
Country: USA

Re: Remote Database Synchronization Failure

Thank you Jared. That helps me greatly.