How can you remove the "This procedure is already being edited" message if the TIBCO iProcess Modeler had been in use when a client machine crashed?

How can you remove the "This procedure is already being edited" message if the TIBCO iProcess Modeler had been in use when a client machine crashed?

book

Article ID: KB0089685

calendar_today

Updated On:

Products Versions
TIBCO iProcess Engine (SQL) -
Not Applicable -

Description

Resolution:
If while creating a new or editing a procedure the TIBCO iProcess Modeler is killed it is possible for the lock on the procedure to be left behind.

There are two tables in the database that can contain procedure locks.
pm_objects_lock
procedure_lock

Delete the entries for the locked procedure in both tables to unlock the procedure for editing.

Example in SQL:

delete procedure_lock where proc_id = (select proc_id from
proc_index where proc_name = ’PROCNAME’)

delete pm_objects_lock where object_guid = (select object_guid from
pm_objects where object_name like ’PROCNAME’)

NB: Care should be taken when deleting rows from the database.

Issue/Introduction

How can you remove the "This procedure is already being edited" message if the TIBCO iProcess Modeler had been in use when a client machine crashed?