Why does AX 2012 data import from staging to target always overwrite 1 record?

(0) Share

Report

Posted on by bRadlyJames

2,145

I have a custom table that I am trying to import data into. When importing into my staging table, I get 3 separate records. When importing from staging to target, it will create 1 record (if there are no records) and then 'update' that record twice. If there is already a record in the target, it will update that record 3 times.

I'm fairly certain this has something to do with this table(target) being a custom table, however, I can't figure out why the records always update. They are unique records.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

André Arnaud de Cal... 301,025 Super User 2025 Season 2 on at

Like (0)

Report

Hi Bradly,

You have to ensure your DMFstaging table has a primary index including the fields DefinitionId, ExecutionId and the primary key of the target table.

Also check if the DMF staging table has a relation with the target table on your primary field. This might be your problem.

Check e.g. the relations on an existing DMF staging table.

Was this reply helpful? Yes No
Erik Paulsson 40 on at

Like (0)

Report

Like Andre says, it seems like DMF has trouble finding the specific records you are trying to insert/update. The result is that the first record in the target table is always found.

DMF uses the relations on the staging table to find records, if the exist. It does this by building a query in code with the DMFStaging table as base and then adds the related table using the relation. If the related record can not be found you will get an insert and if it can be found you will get an update. But if there is no relation at all, the first record of the target table will be found every time and this seems to be your problem.

Was this reply helpful? Yes No
bRadlyJames 2,145 on at

Like (0)

Report

Thank you Andre! It was the relationship between the staging and target tables that I was missing. Thank you!!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks André! the relation between DMF staging table and target table solved my problem :)

Was this reply helpful? Yes No