This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.
Summary
Error
SQL Command failed while upgrading the project from ALM 11.52 to ALM 12.21
The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'td.LISTS' and the index name ... 'LS_LOGICAL_NAME_IDX'. The duplicate key value is (hp.qc.plan-status.imported).
Failed SQL: /* ~~QC */CREATE UNIQUE NONCLUSTERED INDEX [LS_LOGICAL_NAME_IDX] ON [LISTS]([LS_LOGICAL_NAME])
Cause
Fix
Run the below query to find the fields which have same value for column LS_LOGICAL_NAME and make changes so that all LS_LOGICAL_NAME columns are unique.
SELECT
LS_LOGICAL_NAME,
COUNT(*)
FROM
LISTS
GROUP BY
LS_LOGICAL_NAME
HAVING
COUNT(*) > 1
Once that is done, continue the upgrade process.