Synchronization Duplication

  • 29Views
  • Last Post 06 July 2022
Rob Moulton posted this 01 July 2022

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

Order By: Standard | Newest | Votes
Rob Moulton posted this 06 July 2022

Is anyone paying attention to support tickets?  4 days and no respoinse.

Nataliia Nikulina posted this 06 July 2022

 Hello Rob,

Thank you for contacting Skyvia Support team.

Please send us the example of run Id and the example of duplicated records.

We look forward to hearing from you. 

Best regards,