Answered

Uniqueness not being enforced for one table but working correctly for another

(1) Share

Report

Posted on by Rutu01

305

I have a Unique Key (on the Name Column) for many tables. While it is working fine for most tables, for atleast one table, the uniqueness is not being enforced. I tried deleting the key and republishing too.

What can i do to prevent duplicates. Feels like a bug as its working ok for some tables but not for all

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Rutu01 305 on at

Like (2)

Report
Copy link

Link copied!
In the system jobs I have found the following message Index creation failed for Entity Key 'jg_nameuq' on Entity 'jg_itemtype' due to duplicate key records found in the database for the selected columns: 'jg_name'.
Index creation failed for Entity Key 'jg_nameuq' on Entity 'jg_itemtype' due to duplicate key records found in the database for the selected columns: 'jg_name'.
, so i will try to delete duplicates and try creating the key again

Was this reply helpful? Yes No
Rutu01 305 on at

Like (0)

Report
Copy link

Link copied!

I deleted all duplicate records, But the key creation i still failing with the same error

Was this reply helpful? Yes No
Rutu01 305 on at

Like (0)

Report
Copy link

Link copied!

Turns out there were duplicates between the inactive and active records, deleted them, deleted and recreated the key and now all is working as expected

Was this reply helpful? Yes No