A record that has the attribute values Asset Record ID already exists. The entity key Master Record ID requires that this set of attributes contains unique values. Select unique values and try again.
You have an Entity Key on your table called "Master Record ID". This key is set up to enforce a uniqueness rule, and it's linked to the "Asset Record ID" column (attribute).
The error "A record that has the attribute values Asset Record ID already exists" simply means you are trying to save a record with an 'Asset Record ID' that is already being used by another record in that table. Entity Keys do not allow duplicates.
How to Fix It:
Check Your Data: The value you are trying to submit for 'Asset Record ID' is not unique. You must provide a different value that doesn't already exist in the database.
Check Your Logic (If this is intentional): If you expect to have duplicate 'Asset Record ID' values, then you should not have this key enabled. You can remove the "Master Record ID" key from your table's configuration.
You can manage your table's keys by navigating to Tables > [Your Table Name] > Schema > Keys (as shown in your first screenshot). There you can see the key and which columns it affects.
1 people found this reply helpful.
Was this reply helpful?YesNo
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.
3
Share
Report
All responses (
Answers (
