Remote Database Synchronization Failure

[MartyinPlano]

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.

[gmartin · Accepted solution]

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

[gmartin · Accepted solution]

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

[Jered]

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?

[Jared Dalrymple]

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

[Jered]

Thank you Jared. That helps me greatly.

[mgawronski]

tried to find the KB Article 28141 - it appears to be missing - anyone know where it went

[mrogers]

Follow the link provided by Jared below.