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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Service | Customer Service, Contact Center, Fie... / Removal of a Key doesn...
Service | Customer Service, Contact Center, Fie...
Suggested Answer

Removal of a Key doesn't seem to remove constraint on entity field

(0) ShareShare
ReportReport
Posted on by crham 390

I created a solution and added a few existing tables we'd like to customize slightly.

One of those tables is the Unit Group.  We created a key on the Name field requiring it to be unique.

HOWEVER, I first accidentally did that to the Unit table, then imported some records, then when I tried to create a new group with a Base Unit with the same name that another group uses it gave me the error below.  It was then that I realized I had created a key on the Unit table's Name field too.  So I deleted that key but still get the error.

Is there something else I need to do to remove that constraint?

A record that has the attribute values {1} already exists. The entity key {0} requires that this set of attributes contains unique values. Select unique values and try again.

I have the same question (0)
  • Suggested answer
    Abdul Wahab Profile Picture
    Abdul Wahab 12,119 Moderator on at

    Hi crham,

    Make sure you deleted the key from the correct environment and you are no longer to find it from the default solution.

    For to refresh metadata. Perform the below actions may be any from the below work for you

    1. Publish the table and check
    2. Create a new dummy column and check. (If it worked do not forget to delete)
    3. Create a key with that column and check. (If it worked do not forget to delete)
  • crham Profile Picture
    crham 390 on at

    I confirmed it wasn't in the default solution and that it was published.  Still failure.

    I didn't feel like chasing rabbits so I just started from a base environment and moved on.

    Thanks for responding for at least something for me to try.

  • Suggested answer
    Abdul Wahab Profile Picture
    Abdul Wahab 12,119 Moderator on at

    Hi crham,

    Did you create a new dummy column? and it is not working for you.

    Did you create a new dummy key? and it is not working for you.

    Am I right?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 57 Super User 2025 Season 2

#2
Daniyal Khaleel Profile Picture

Daniyal Khaleel 34 Most Valuable Professional

#3
Scott Jackson UK Profile Picture

Scott Jackson UK 22

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans