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

All responses (3)

Answers (1)

Rutu01 305 on at

Like (0)

Report

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

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
Rutu01 305 on at

Like (0)

Report

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

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

Rutu01 305 on at

Like (2)

Report
Re: Uniqueness not being enforced for one table but working correctly for another

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