Release Automation

Expand all | Collapse all

Tech Tip : How to unlock a blocked process

  • 1.  Tech Tip : How to unlock a blocked process

    Broadcom Employee
    Posted 01-30-2017 02:59 AM

    While trying to edit a process the following error occurs:

    The graph you are attempting to edit is being edited by another user -  xxxxx

    Error Message :

     

    If a user is in the middle of editing a process(leaves it unattended) and another user tries to edit the same process,

     

    Release Automation does not allow multiple users to edit the same process simultaneously.

     

    Multiple users can view the process, but only one can update at a given point in time.

     

    If the problem occurs, the process can be unlocked via SQL Queries.

     

    The following query lists the process that are blocked:

    Select * from edited_process WHERE work_state <> 'IDLE'

     

    If the query returns any value, make a note of the ORIGINAL_PROC_ID and run the following query to unlock the process:

    Update edited_process set work_state = 'IDLE' WHERE original_proce_id = {process_id}

    Note: {process_id} is the ORIGINAL_PROC_ID returned by the first query.

     

    Example :

    Check process_id

     

    update query

     

    ****Important Note: Always take a backup of the database before running an update query.



  • 2.  Re: Tech Tip : How to unlock a blocked process

    Posted 06-26-2017 10:18 AM

    This is a very useful tip.  

     

    I just wanted to add that you can find the ORIGINAL_PROC_ID value from the RA UI as well:

    http://myserver:8080/datamanagement/#/main/studio/process_design/applications/6/components_view/flows/96060

     

     

    In this case, trying to view/edit the process at the above URL results in the message you indicated.  The value 96060 is the ORIGINAL_PROC_ID you can use int he update query.