When we try to refresh some of our virtual tables, it is failing and giving the error: Violation of UNIQUE KEY constraint 'UQ_LocalizedLabelCheck'. Cannot insert duplicate key in object 'MetadataSchema.LocalizedLabel'.
My question is what do I do to fix this error and where would I go to . I looked at the Dynamics 365 settings options and can't find a way to access SQL to supposedly delete the duplicate key. I understand this might overlap with D365 and I will post in the appropriate forum there as well but I am hoping that some people here would recognize the error message and assist me in understanding what to do better.
Error code: 0x80048d0bSession Id: 82166623-45e0-49c2-bf87-e5f3a6197d32Activity Id: 1d637cf8-7929-4387-aac6-f073a94b49adTime: Thu Jan 12 2023 09:08:48 GMT-0800 (Pacific Standard Time)
Log file header:
Exception Message: Failed to create entity with logical name mserp_customentity and object type code 10530. Exception: System.Data.SqlClient.SqlException (0x80131904): Violation of UNIQUE KEY constraint 'UQ_LocalizedLabelCheck'. Cannot insert duplicate key in object 'MetadataSchema.LocalizedLabel'. The duplicate key value is (c8e966aa-96ca-b866-df9e-e497489bdddb, displayname, 1033, Jan 1 1900 12:00AM, 0).
the issue has been fixed by MS
This is microsoft bug. we have raised the ticket and solved it today.
I just ran into the same issue. Did you ever figure out the fix for this?
Hi ! I'm having the same issue. Do you have by any chance found a solution ?
Fubar
69
Super User 2025 Season 1
oliver.rodrigues
49
Most Valuable Professional
Jon Unzueta
43