MirrorSync trying to insert records multiple times

[_ian]

Hi

I've come up with a solution for a problem I had last week and wanted to post it here in case it helps anyone else. We had a strange thing with our MirrorSync server last week - the internal database got out of sync with the FileMaker Server (Hub) and the SQL Server (Spoke), so it kept trying to add Suppliers that had already been added to SQL Server and returning error messages for each one. The suppliers had been added to the SQL Server spoke, but MirrorSync kept trying to add them again. I checked and we had no duplicate keys in the FileMaker database so that wasn't the problem.

My solution was to switch off the SQL server error reporting for duplicate keys on the table in question
executed this on the SQL SERVER:

ALTER TABLE [Suppliers] REBUILD WITH (IGNORE_DUP_KEY = ON) 

run a sync - the redundant additions failed silently and MirrorSync updated it's internal database to record the addition.
then back to the SQL Server to run

ALTER TABLE [Suppliers] REBUILD WITH (IGNORE_DUP_KEY = OFF)

Run a sync again and everything's happy now.