01-11-2013 05:21 PM
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.
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.
01-30-2014 09:06 AM
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?
01-30-2014 03:35 PM - edited 01-30-2014 03:35 PM
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