I tried to check the errors on this syncing issue but how can I resolve the duplicate issue on this
I only have 188 errors here with same error problem for each
Options
Inc Updates checked
Create table checked
create foreign key checked
Hi,
Thank you for submitting a ticket with us.
Please let us know the ID of the package in question or its name.
We are looking forward to hearing from you.
The name is IGNORE-Hubspot_Schema
Hi,
Thank you for getting back to us.
The package failed with this error message: "Duplicate entry '5137290779' for key 'PRIMARY'"
There can be 3 reasons for such error:
1. LastSyncTime was reset and Skyvia moves a copy of the same data that was already moved to the target database.
2. Failure of previous run in the middle of its execution
3. Bug in HubSpot provider and returning not unique values of their private key in Companies
We tend to think in first point for your case.
If you reset LastSyncTime parameter, we would recommend selecting 'Drop Tables' option in the replication package details. All data will be migrated from scratch.
Should you have any questions, do not hesitate to contact us back.
