Clarity PPM: How to remove orphan project records in the PRLOCK table

Document ID : KB000123762
Last Modified Date : 26/12/2018
Show Technical Document Details
Issue:
We see several records in the PRLOCK table but it cannot be removed from the security.locks page in the UI.

 
Cause:
This can happen when the investment is deleted by the Delete Investments job, but the project is still locked from OWB or MSP.

STEPS TO REPRODUCE

1. Create Project
2. Inactivate it
3. Mark for Deletion
4. Open in OWB
- note it is in PRLOCK table as well as security.locks
5. Leave OWB open so it remains in PRLOCK
6. Run Delete Investments

Expected Results: entry is removed from PRLOCK table as well as security.locks

Actual Results: entry remains in PRLOCK but is not visible in security.locks
 
Resolution:
1. Verify that the investment is no longer in the database

Obtain the database investment id and run the following query:

select * from inv_investments where id  = 5xxxxxx

If no records are returned, have the DBA team run the query to remove the orphan record(s).

delete from PRLOCK
where PRTABLENAME = 'SRM_PROJECTS'
and PRRECORDID = 5xxxxxx;

commit; 

For SaaS customers,  please contact the Support team.
 
Additional Information:
This is reported as DE44167 and has been fixed in 15.5.0.1