The duplicate key value is (0, Jan 1 1900 12:00AM, manualsla_{customEntityLogicalName})

(2) Share

Report

Posted on by Saidev3

I’m attempting to import a managed solution from our DEV environment into QA and encountered the following error:

Solution "{solutionName}" failed to import: ImportAsHolding failed with exception: Import failed: Cannot insert duplicate key row in object 'MetadataSchema.EntityRelationship' with unique index 'ndx_for_entitykey_UniqueEntityRelationship'. The duplicate key value is (0, Jan 1 1900 12:00AM, manualsla_{customEntityLogicalName}). The statement has been terminated.

We have enabled SLA on this custom entity and this entity is

Has anyone experienced this issue before or have suggestions on how to resolve it?

Categories:

Dynamics 365 general

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

DAnny3211 11,397 on at

Like (0)

Report
Hi saidiev3,

The error you're encountering during solution import:

Cannot insert duplicate key row in object 'MetadataSchema.EntityRelationship'...

is typically caused by a conflict in SLA configurations on a custom entity when importing a managed solution. The key part of the error — (0, Jan 1 1900 12:00AM, manualsla_{customEntityLogicalName}) — suggests that the system is trying to insert a duplicate SLA relationship.

Here are a few steps to resolve it:

Check SLA Configuration: Ensure that SLA is not already enabled on the target environment (QA) for the same custom entity.

Remove Existing SLA: If SLA is enabled in QA, try disabling it temporarily before importing the solution.

Clean Up Holding Solution: If a previous import failed, a holding solution might still exist. Use the Solution History or Advanced Find to locate and delete it.

Export as Unmanaged First: Try exporting the solution as unmanaged from DEV, import it into QA, then convert it to managed if needed.

Microsoft Support: If the issue persists, consider raising a ticket with Microsoft as this may involve deeper metadata conflicts.

Let me know if this helps!
If the answer was useful, please mark it as helpful so others can benefit too. 😊

Best regards,
Daniele Incalza

Was this reply helpful? Yes No