Failed to insert record into staging table. The keys of the record are DEFINITIONGROUP, EXECUTIONID, PARTITION, RECORDID

Finance and Operations/AX General discussions
1

Hello everyone, I hope you are fine.

I want to import File " Sales price agreement" in data management, So I get this error

“Failed to insert record into staging table. The keys of the record are DEFINITIONGROUP, EXECUTIONID, PARTITION, RECORDID. Duplicate records must be removed from the file prior to import.-The duplicate key value is (5637144576, sales price agrem import, sales price agrem import-2023-01-04T02:58:54-33403ECEC3654302B2CB7412E42A824C, 0)
‘0’ ‘Sales price agreements’ record(s) inserted in staging”

So, I tried to auto increment the “RECORDED ID” but doesn’t work. it’s send me a message

"Non-editable fields were not allowed to mark as Auto default or Auto-generated "

0001
0001700×567 37.9 KB

2

SalesPriceAgreementEntity should be read-only, IMHO. Trying to import records directly to PriceDiscTable is logically wrong and setting RecId from outside isn’t possible.

3

Thanks I will try it

4

I didn’t find “PriceDiscTable” in the Export DATA MANAGEMENT

5

I’m not going to duplicate all my replies at two places. Let’s continue the discussion in the other thread only.