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, sal

(0) Share

Report

Posted on by amineit

205

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 "

All responses (7)

Answers (0)

amineit 205 on at

Like (0)

Report

RE: 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,

Thank you so much
Martin Dráb 233,066 Most Valuable Professional on at

Like (0)

Report

RE: 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,

I guess that Trade agreement journal headers V2 (TradeOpenTradeAgreementJournalHeaderV2Entity) + Open sales proce journal lines V2 (SalesOpenSalesPriceJournalLineV2Entity) would do the job.
amineit 205 on at

Like (0)

Report

RE: 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,

One question, please,

How I can import lists of sales price items at one time?
amineit 205 on at

Like (0)

Report

RE: 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,

Thank you Sir
Martin Dráb 233,066 Most Valuable Professional on at

Like (0)

Report

RE: 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,

PriceDiscTable is a table, not a data entity. It's a data source of SalesPriceAgreementEntity, therefore you're already trying to import data to PriceDiscTable when you're importing through SalesPriceAgreementEntity. And I'm arguing that it's a wrong thing to do. Changes to prices should be done through trade agreement journals instead of written directly to PriceDiscTable. Trade agreement journal tables are used in several entities, such as Trade agreement journal headers.
amineit 205 on at

Like (0)

Report

RE: 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,

I didn't find "PriceDiscTable" in the Export DATA MANAGEMENT
Martin Dráb 233,066 Most Valuable Professional on at

Like (0)

Report

RE: 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,

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