I have a Synchronization job, from Harvest to SQL, that has been working fine for months. About 2 weeks ago, something changed (on the Skyvia side, nothing changed on my SQL server). Now, when the sync runs, time entries that have already been synced once, but have been modified, are getting inserted in my SQL table a second time. For example, when a time entry is invoiced, it gets updated with the invoice number. When it syncs over, I get a second row with the same unique ID, but the updated info. So I have to now setup a SQL job that locates the earlier duplicate, and deletes it. What a pain!
What changed on the synchronization that would cause this, and what do I do to prevent it? The Synchronization job doesn't give me anything to identify the PK... so I can't fix it myself.
Thanks. Rob
