We see several records in the PRLOCK table but it cannot be removed from the security.locks page in the UI.
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
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;
For SaaS customers, please contact the Support team.
This is reported as DE44167 and has been fixed in 184.108.40.206