ALM 15 project realignment failing

Question ID: 109760
1
1

Hello. We have run into a problem. After cleaning up a project in ALM 15 the realign fails with this error:

2:44:42.43     – DB Tables Population thread inserted batch of 4281 records in 2 seconds. SQL time for batch (milliseconds): 63

2020-02-18 22:44:43.383  Adding unique constraint for temporary table

2020-02-18 22:44:44.277  Exception occurred. Message: [Mercury][SQLServer JDBC Driver][SQLServer]The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name …

2020-02-18 22:44:44.283  ‘dbo.SMART_REPOSITORY_ALIGNER_TEMP’ and the index name ‘SRAT_PRIMARYKEY’. The duplicate key value is (.\ProjRep\000\000\001\283\758). Failed SQL: /* ~~QC */ ALTER TABLE SMART_REPOSITORY_ALIGNER_TEMP …

2020-02-18 22:44:44.287  ADD CONSTRAINT SRAT_PRIMARYKEY PRIMARY KEY (SRAT_PATH)

2020-02-18 22:45:09.313  Dropping temporary table for optimized repository realigning

2020-02-18 22:45:09.323  Tool aborted

Marked as spam
Posted by (Questions: 216, Answers: 20)
Asked on July 31, 2020 1:11 pm
3 views
Answers (1)
1
Private answer

Hello. I have seen this issue before, and it was resolved when the user refreshed their session. Try refreshing your session to see if you can activate the project afterwards.

Marked as spam
Posted by (Questions: 2, Answers: 277)
Answered on July 31, 2020 1:12 pm
After refreshing my session, I was able to successfully activate the project. Thanks for your help!
( at July 31, 2020 1:12 pm)