CA PPM Orphan Records in PRLOCK SRM_PROJECTS

Document ID : KB000123762
Last Modified Date : 26/12/2018
Show Technical Document Details
Issue:
We see several records in prlock where PRNAME= prImportExport and PRTABLENAME = SRM_PROJECTS but the records are not available to delete from the UI under security.locks.
Cause:
This can happen when the investment is deleted from Delete Investments job, but the project was 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:
Verify that the investment is no longer in the database using following query:
Note: For this example my PRRECORDID = 5008011 in the prlock table.


                   select * from inv_investments where id  = 5008011

If no records are returned, you can delete the record from the prlock table using this query (change the prrecordid to match yours)

                  delete from PRLOCK where PRTABLENAME = 'SRM_PROJECTS' and PRRECORDID = 5008011
                  commit; (oracle users)

For SaaS customers please open a support case so the records can be deleted.
 
Additional Information:
This has been reported as Defect DE44167 and has been fixed in 15.5 01.