Importing data in EcomStockUnit table leads to duplicate records

Hans Kloppenborg

Posted on 14/12/2022 10:50:52

Hello,

We have a dataintegration import on the EcomStockUnit table, where every import creates a new record for each row we import, because of the autonumber Id key field. The setting to delete rows that do not exist in the source does nothing.

EDIT: It seems the duplicates only are created for rows where the stockunitId is 0. No clue why

Does anyone know how to import to this table with DataIntegration? I can show the Id row in the mapping, but as far as I know you cannot insert your own value in a Identity field.

The application does work with all the duplicate rows, but it slows down massively the first time the units get loaded (20 seconds for the 3 million rows for 19000 unique values).

Greetings,

Hans

Replies

Dmitriy Benyuk

Posted on 14/12/2022 12:23:50

This post has been marked as an answer

Hi Hans,
you can try to set the other columns as a Key columns for the table StockUnit table mapping:

And you probably will also need the "StockUnitStockLocationId" being selected in he Key columns list.

And also check the "Discard duplicate key rows":

So in that case it will not create such duplicates.

BR, Dmitrij

Votes for this answer: 1

Hans Kloppenborg

Posted on 14/12/2022 13:09:32

Hey Dmitriy,

Have tested your solution and it works, thanks for the help.

Greets Hans

You must be logged in to post in the forum

Developer forum

Importing data in EcomStockUnit table leads to duplicate records

Replies