PRLOCK Table Contains Process Engine Lock

Products

• Clarity PPM On Premise

Issue/Introduction

There are several entries in the PRLOCK table of type PROCESS_ENGINE. 
The prlockedsince date is old.

Is there a way to match the lock to a process?  If there is no match, can the record be deleted from the PRLOCK table?

 

Environment

Release : 15.9

Component : CA PPM APPLICATION

Resolution

If a process is marked as a singleton, where it cannot have more than one running and it is set up as autostart, the process engine will lock when ready to start the process.
When the process is started, the lock is released. Something happened between when the lock was obtained and when it should have released that left the lock orphaned.

1. Take a backup of the table for reference/history
2. Run the SQL:

delete from PRLOCK 
where prname = 'PROCESS_ENGINE';
commit;