I've recently had a few issues with the destination component, specifically duplicates. When the destination is set to "Bulk Insert" it's inserting duplicates into my table, but it doesn't do this to all of the records. So when I change the operation to "Insert", my data goes in fine with zero duplicate records.
Is this a bug? Or am I missing something?
Thanks,
Tom
Devart MySql Destination Duplicates
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Devart MySql Destination Duplicates
The "Bulk Insert" operation unites several inserts in one batch. If one of the inserts causes an error, it re-executes inserts one-by-one. Probably the records before the error were inserted successfully, and then the same records are re-inserted. We will investigate this behaviour and notify you about the results.
Please use usual inserts as a workaround for now.
Please use usual inserts as a workaround for now.
-
- Posts: 11
- Joined: Thu 01 Jun 2017 12:54
Re: Devart MySql Destination Duplicates
Thanks for the quick reply.
I've updated the operation to "Insert" and it's working fine; albeit a little bit slower
I've updated the operation to "Insert" and it's working fine; albeit a little bit slower