Unanswered

Error 8004801E Import failed: Violation of UNIQUE KEY constraint 'UQ_LocalizedLabelCheck'. while importing a solution

(0) Share

Report

Posted on by Thomasrainer

Hi All,

I'm importing a solution in a D365 prod env (the same solution was imported correctly in 2 others envs on the same organization) but the import return this error:

Import failed: Violation of UNIQUE KEY constraint 'UQ_LocalizedLabelCheck'. Cannot insert duplicate key in object 'MetadataSchema.LocalizedLabel'. The duplicate key value is (2f2e4bdc-cb4d-42a9-902d-89234dc8d6e5, DisplayName, 1055, Jan 1 1900 12:00AM, 2). The statement has been terminated.

I'm trying to detect the label that I should delete but I can't find it, have you got any suggestions?

Thanks

Thomas

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Sort by

ChristianAbata 8,953 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

hi @Thomasrainer the error is describing that in that environment you have a value and that one is unique. So I recommend you to do a filter in dataverse using this GUI 2f2e4bdc-cb4d-42a9-902d-89234dc8d6e5, then delete.

Was this reply helpful? Yes No
Fubar 8,487 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Export the Solution out as Unmanaged, unzip it, then search the Customizations.xml file for the GUID.

Was this reply helpful? Yes No
domliu37 314 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Thomasrainer ,

If you know which table contains that record Guid : 2f2e4bdc-cb4d-42a9-902d-89234dc8d6e5, DisplayName, 1055, Jan 1 1900 12:00AM, 2, then delete it.

Otherwise do what @Fubar suggested, just delete that line in the xml file

Cheers,
Dom

Was this reply helpful? Yes No
Fubar 8,487 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Note: I was not suggesting deleting out of the XML, but it will let you identify what it believes the duplicate item is. You would the look at if you can remove the item from the Target instance, if not, add a new item and remove the conflicting item from your source dataverse instance.

Was this reply helpful? Yes No
Thomasrainer 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @Fubar ,
thanks for the answer to my question, we did some checks and we wasn't able to find the guiid inside the customizations.xml.
We succeed to import the solution only after removing labels of each languages, except of english, from customizations.xml.

Do you have some suggestions?

Thanks,
Thomas

Was this reply helpful? Yes No