CREATE UNIQUE INDEX terminated because a duplicate key was found.

[Former Member]

Hi All,

I am facing an error while applying the patches for CRM 5.0. The error as per the log file is that index "WFMCAS_WRKAREA ~01 in SQL cannot be completely created". Using SE14 I checked for the inconsistencies, it indicates that the above mentioned index is missing in the SQL database, so it should be created manually. When I tried to create the same, the displayed error is

Server: Msg 1505, Level 16, State1

CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 2. Most significant primary key is '800'

If the index is not UNIQUE it's being created successfully but, the requirement is it should be UNIQUE.

Unless it is unique the table doesn't become consistent.

Can anyone please help me out in solving this error ?

[JPReyes]

Moved to SQL forum