After making a project copy, the source project is hung in a deactivated state

Question ID: 109412
1
1

Hello. We created a project copy, and now the source project won’t reactivate. The new project is working fine, but the source project is hung in a deactivated state. I have entered the messages that I found in the sa logs from around the time the issue occurred. I appreciate any information that you can provide. Thanks!

Messages:

Failed to Set Projects Properties; Failed to set projects properties; Failed to set project properties : project ‘WEX_Testing_Project’ is currently in status Source for borrow;

Stack Trace:

com.hp.alm.platform.exception.CTdException: Failed to set project properties : project ‘WEX_Testing_Project’ is currently in status Source for borrow.

Marked as spam
Posted by (Questions: 202, Answers: 14)
Asked on March 25, 2020 2:23 pm
3 views
Answers
1
Private answer

Hello. I have seen this issue before, and it was resolved by performing the following steps. On a SQL server database, you will need to locate the PROJECTS table in the qcsiteadmin database, and set the value in the PR_IS_ACTIVE column to ‘Y’ using the query below. After you have set the PR_IS_ACTIVE value back to ‘Y’, you will then need to restart the database and ALM services. Once the database and ALM are back up and running, access Site Administration and check to see that the project is now active.

UPDATE PROJECTS SET PR_IS_ACTIVE = 'N' WHERE PROJECT_ID = %PROJECT_ID%

Marked as spam
Posted by (Questions: 2, Answers: 263)
Answered on March 25, 2020 2:25 pm