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 "

I have the same question (0)

All responses (7)

Answers (0)

Martin Dráb 236,677 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.

Was this reply helpful? Yes No
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

Was this reply helpful? Yes No
Martin Dráb 236,677 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.

Was this reply helpful? Yes No
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

Was this reply helpful? Yes No
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?

Was this reply helpful? Yes No
Martin Dráb 236,677 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.

Was this reply helpful? Yes No
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

Was this reply helpful? Yes No