Duplicate Issue

  • 72Views
  • Last Post 16 February 2021
0
votes
Placester: Skyvia posted this 12 February 2021

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

Attached Files

Order By: Standard | Newest | Votes
0
votes
Dmitriy Muzurov posted this 15 February 2021

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.

0
votes
Placester: Skyvia posted this 15 February 2021

The name is IGNORE-Hubspot_Schema

0
votes
Dmitriy Muzurov posted this 16 February 2021

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.

Close