Export is failing in composite data entities

(0) Share

Report

Posted on by nithinkumar_007

152

Hi,

I have created a composite data entity using the following link: https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/develop-composite-data-entities

Importing composite entities is working fine, when I am trying to export it is showing an error "cannot create a record. The record already exists in the data entity."

I have two tables

Table1:

Fields: Rollnumber (Primary index)

Name

Table2:

Fields: Rollnumber (Primaryindex)

TotalMarks

Table1 and Table2 are related by the field Rollnumber using normal relation.

Could anyone help me with this.

Thanks,

Nithin

I have the same question (0)

All responses (15)

Answers (1)

Sergei Minozhenko 23,095 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Most likely you have an issue with StagingIdx index for table2 staging table. Is the relation between Table1 and table2 done as one-to-many?

Was this reply helpful? Yes No
Martin Dráb 239,040 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Are you sure it's about export? Export shouldn't write anything to entities; that's what import does.

Isn't it possible that the message is correct; that you already have records in database with the same Rollnumber?

Do your entities work correctly if you use them directly, not though a composite entity?

Was this reply helpful? Yes No
nithinkumar_007 152 on at

Like (0)

Report
Copy link

Link copied!

Hi Martin,

Sorry the error message is "Cannot create a record in Studentsubjectdetails_nitStaging (Table2)(Studentsubjectdetails_nitStaging). The record already exists."

The entities are working correctly if I use them directly.

Please refer to the below screenshot

Thanks,

Nithin.

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,042 on at

Like (0)

Report
Copy link

Link copied!

is this export to BYOD?

check target data and data being exported for their primary key violation and suggest

Was this reply helpful? Yes No
Suggested answer

Sergei Minozhenko 23,095 on at

Like (0)

Report
Copy link

Link copied!

Hi Nithin,

When you export data through composite entity data is exported to staging tables first.

First, you need to check if unique indexes on staging tables (Studentsubjectdetails_nitStaging) are made correctly.

I suspect that you have a StagingIdx index for table Studentsubjectdetails_nitStaging with only RollNumber field (in addition to DefinitionGroup and ExecutionId) and you need to add more fields to make it unique, for instance, subjectId or check the list of fields from the unique index for source table (Studentsubjectdetails_nit).

Was this reply helpful? Yes No
nithinkumar_007 152 on at

Like (0)

Report
Copy link

Link copied!

Hi Sergei,

I have adding Linenumber in stagingIdx for table StudentSubjectdetails_nitStaging, it is showing the same error.

Thanks,

Nithin.

Was this reply helpful? Yes No
Sergei Minozhenko 23,095 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Do you have other unique indexes on StudentSubjectdetails_nitStaging table? It would be helpful if you could share the list of unique indexes and fields in it.

Was this reply helpful? Yes No
nithinkumar_007 152 on at

Like (0)

Report
Copy link

Link copied!

Hi Sergei,

Please find the below screenshot which contains the details of the table

Thanks,

Nithin.

Was this reply helpful? Yes No
Sergei Minozhenko 23,095 on at

Like (0)

Report
Copy link

Link copied!

Hi Nithin,

Are you sure you don't have duplicates by RollNumber and LineId in StudentSubjectdetails_nit table?

Was this reply helpful? Yes No
nithinkumar_007 152 on at

Like (0)

Report
Copy link

Link copied!

Hi Sergei,

The table StudentSubjectdetails_nit has only two records which I imported from the following XML file.

The records in the table StudentSubjectdetails_nit are as shown

Thanks,

Nithin.

Was this reply helpful? Yes No