Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Pages - General Discussions
Unanswered

Refreshing a Virtual Table is giving a Violation of UNIQUE KEY constraint 'UQ_LocalizedLabelCheck'. Cannot insert duplicate key in object 'MetadataSchema.LocalizedLabel'

(0) ShareShare
ReportReport
Posted on by 167
Hi, 

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.

gospa_2-1673543526018.png

 

 

gospa_0-1673543293431.png

gospa_1-1673543337906.png

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

Categories:
  • nataraja Profile Picture
    4 on at
    Re: Refreshing a Virtual Table is giving a Violation of UNIQUE KEY constraint 'UQ_LocalizedLabelCheck'. Cannot insert duplicate key in object 'MetadataSchema.LocalizedLabel'

    the issue has been fixed by MS

  • nataraja Profile Picture
    4 on at
    Re: Refreshing a Virtual Table is giving a Violation of UNIQUE KEY constraint 'UQ_LocalizedLabelCheck'. Cannot insert duplicate key in object 'MetadataSchema.LocalizedLabel'

    This is microsoft bug. we have raised the ticket and solved it today.

  • HardyRick Profile Picture
    15 on at
    Re: Refreshing a Virtual Table is giving a Violation of UNIQUE KEY constraint 'UQ_LocalizedLabelCheck'. Cannot insert duplicate key in object 'MetadataSchema.LocalizedLabel'

    I just ran into the same issue.  Did you ever figure out the fix for this?

  • dev0123456 Profile Picture
    2 on at
    Re: Refreshing a Virtual Table is giving a Violation of UNIQUE KEY constraint 'UQ_LocalizedLabelCheck'. Cannot insert duplicate key in object 'MetadataSchema.LocalizedLabel'

    Hi ! I'm having the same issue. Do you have by any chance found a solution ?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Pages

#1
Fubar Profile Picture

Fubar 69 Super User 2025 Season 1

#2
oliver.rodrigues Profile Picture

oliver.rodrigues 49 Most Valuable Professional

#3
Jon Unzueta Profile Picture

Jon Unzueta 43