SAP MDM 7.1 - Unique constraint (DUNS code (Cred.info no.)) in table Vendors; is violated.

[Former Member]

Hello All,

One morning i wanted to reload our VENDOR_Catalog_DEV Repository with update indices.

It failed because of 1 fatal Error.

Fatal Error :

Unique constraint (DUNS code (Cred.info no.)) in table Vendors; is violated.

There are duplicate records in the field(s)

-> Correction n°1 (Failure)

Check Repair Option deleted Unique constraint (DUNS code (Cred.info no.)) in table Vendors to permit us to load Repository in order to correct the issue.

When Loaded MDM Content Administrator corrected duplicated Label.

I checked this table on MDM Data Manager, there is no more duplicated Label on DUNS Code (Cred info no) Column.

When i put again Unique constraint (DUNS code (Cred.info no.)) in table Vendors, i had a MDM Popup : "Can not set Unique constraint on table Vendors, because duplicate records exist".

-> Correction n°2 (Failure)

With MDM Console, on Vendor Table, i saw a new Entry :

Position : [122]

Name : DUNS code (Cred.info no.)

Type : Integer

Keyword : None

I archived Repository, i deleted this entry, i tried to add Unique Constraint again

It failed again with same Log Error : "Can not set Unique constraint on table Vendors, because duplicate records exist"

Does someone know how to solve this issue ?

Many thanks for your help

---

Regards

François LECOMTE

[Former Member · Accepted solution]

Download the entire Dunscode and  identify the duplicates , remove the duplicates from the repository and create indexes. it will work.

Thanks

Priya

[Former Member · Accepted solution]

Hello,

Already done as writed in my first Post

---

Regards

François LECOMTE