Alternate keys fails

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Aiden Kaskela 19,696 on at

Like (4)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you! That worked!

Was this reply helpful? Yes No
Armine DD 288 on at

Like (0)

Report

Thanks, your suggestion helped me too!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you @aidenkaskela, that helped me too.

Was this reply helpful? Yes No