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

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

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".

Was this reply helpful? Yes No
Peter John 288 on at

Like (0)

Report

Hi Gunjan Bhattacharyya ,

Please refer the below screenshot,

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Could you please share the target mapping as well?

Was this reply helpful? Yes No
Peter John 288 on at

Like (0)

Report

Target mapping,

Was this reply helpful? Yes No
Verified answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Peter John 288 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Peter John 288 on at

Like (1)

Report

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

Was this reply helpful? Yes No