web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / Refreshing a Virtual T...
Power Pages
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:
I have the same question (0)
  • dev0123456 Profile Picture
    2 on at

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

  • HardyRick Profile Picture
    15 on at

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

  • nataraja Profile Picture
    4 on at

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

  • nataraja Profile Picture
    4 on at

    the issue has been fixed by MS

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Pages

#1
Jerry-IN Profile Picture

Jerry-IN 71

#2
Fubar Profile Picture

Fubar 62 Super User 2025 Season 2

#3
sannavajjala87 Profile Picture

sannavajjala87 31

Last 30 days Overall leaderboard