ALM 15 project realignment failing
| ♥ 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 |
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 jameslcoleman (Questions: 2, Answers: 300) Answered on July 31, 2020 1:12 pm
|