Custom Dixf Entity process Errors while inserting new records, but its overridden existing records

(0) Share

Report

Posted on by Peter John

288

Hi Everyone,

I have created custom table 'ProdTestTable' with ProdId and Prodname fields. and created custom entity and processing groups as per the standard process in Dixf with CSV formats . After that try to insert new records, for the first time the process was working fine E.g (Prodid = 1 and prodname = One) the records inserting the target entity and custom table (ProdTestTable).

After that i created the template for the next insert process Eg. ProdId =2 and prodName = Two. Here i getting a update for the existing records will overridden ProdID =1 and prodname = one this will update as ProdId - 2 and prodname = two.

Why this things happen? actual the second process will create a new record right . And assigned the prodId as index, no duplicate

And I missed any setup, i followed the below link for the creation of custom entity here i attached FYI and screenshots

https://www.axpulse.com/2017/04/19/developing-a-dixf-entity/

Process -1

Process -2

Table Structures

Please suggest further process.

Thanks in advance

All responses (7)

Answers (1)

Peter John 288 on at

Like (1)

Report

RE: Custom Dixf Entity process Errors while inserting new records, but its overridden existing records

I dnot know what to say, Its working....:) After the relation creations the process working expected thanks Gunjan...
Peter John 288 on at

Like (0)

Report

RE: Custom Dixf Entity process Errors while inserting new records, but its overridden existing records

Yes I saw the target relations are missing, will create and will share update,
Verified answer

Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: Custom Dixf Entity process Errors while inserting new records, but its overridden existing records

Do you have the rigtht relation set between the staging and the target as well?

Please check this thread - community.dynamics.com/.../data-not-written-to-target-table-but-instead-only-updating-records-dixf-dmf
Peter John 288 on at

Like (0)

Report

RE: Custom Dixf Entity process Errors while inserting new records, but its overridden existing records

Target mapping,
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: Custom Dixf Entity process Errors while inserting new records, but its overridden existing records

Could you please share the target mapping as well?
Peter John 288 on at

Like (0)

Report

RE: Custom Dixf Entity process Errors while inserting new records, but its overridden existing records

Hi Gunjan Bhattacharyya ,

Please refer the below screenshot,
Suggested answer

Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: Custom Dixf Entity process Errors while inserting new records, but its overridden existing records

Hi,

Could you please share a screenshot of the DMFXX table index created?

Field ProdId should be a part of that index along with "DefinitionGroup" and "ExecutionId".