Jump to content

MirrorSync trying to insert records multiple times


_ian
 Share

This topic is 1631 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

This topic is 1631 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.