Alternate keys fails

(0) Share

Report

Posted on by Community Member Microsoft Employee

I am trying to create an alternate key on contacts using just the "mobilephone" field. For some reason the status shows failed. The error message I am getting is this one:

"The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.ContactBase' and the index name 'ndx_for_entitykey_new_mobilephone_key'. The duplicate key value is (0)."

Any ideas of what might be wrong?

*This post is locked for comments

All responses (4)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Alternate keys fails

Thank you @aidenkaskela, that helped me too.
Armine DD 280 on at

Like (0)

Report

RE: Alternate keys fails

Thanks, your suggestion helped me too!
Community Member Microsoft Employee on at

Like (0)

Report

RE: Alternate keys fails

Thank you! That worked!
Verified answer

Aiden Kaskela 19,692 on at

Like (4)

Report

RE: Alternate keys fails

Hi,

The alternate key can't be created because it would be violated on create - i.e., you already have two contacts with the same mobile phone number. If you clear out the duplicates you should be good to go.

Hope this helps! I'd appreciate if you'd mark this as Answering your question.

Thanks,

Aiden