IT Process Automation

Expand all | Collapse all

Inactive Processes Hidden in Operations Tab

  • 1.  Inactive Processes Hidden in Operations Tab

    Posted 12-07-2017 10:24 AM

    I have a bizarre situation where there are some processes, 8 of them that are showing in the chart but are not being shown in the table below the chart. See:

    When looking in the database I've found these operations:

     

    Any Ideas as to how i might be able to abort or clean up these processes?



  • 2.  Re: Inactive Processes Hidden in Operations Tab

    Posted 12-07-2017 11:54 AM

    Hi,

    Check if there isn't any operators running. (you  are in process instance view, go to Operator View).

    If you find any, go to the operator properties, and you will see your lost process. there you can delete/complete it.

     

    Another idea is, just access any process link and change the url, the ROID value for the ones in your select. See if you can spot them

     

    Hope it helps



  • 3.  Re: Inactive Processes Hidden in Operations Tab

    Posted 12-07-2017 12:25 PM

    Sorry forgot to mention, I've already tried to access the process by changing the ROID in the query string to no avail. It opens up the workflow but I have no control over it.



  • 4.  Re: Inactive Processes Hidden in Operations Tab

    Posted 12-07-2017 02:02 PM

    Looks like you have some trash in your runtime db.

    You could open a case and let the support team help you safely delete it or, as you shown you know where and how, you could delete yourself, in my opinion.

    Runtime data is only temporary, you could even drop the runtime db (if its separated), and recreate it. 



  • 5.  Re: Inactive Processes Hidden in Operations Tab

    Posted 12-07-2017 02:08 PM

    So delete from C2ORuntimeObjectsARCH where RunState = 'Inactive'?

    or... update C2ORuntimeObjectsARCH set RunState = 'Aborted' where RunState = 'Inactive'



  • 6.  Re: Inactive Processes Hidden in Operations Tab

    Posted 12-07-2017 06:55 PM

    MWNiebuhr, do you see any reason why he couldn't delete the items in his table?



  • 7.  Re: Inactive Processes Hidden in Operations Tab

    Posted 12-11-2017 11:08 AM

    I hesitate to say that it is ok to do this as updating the database is something we in support generally shy away from without buy-in from level 2.  You can easily render a system useless modifying the database directly and make it impossible to recover.  That being said, this seems like it should correct the garbage data you are seeing.  If you move forward with this I would highly recommend a full backup of the database first.  At the very least a backup of the rows you are deleting/modifying.  



  • 8.  Re: Inactive Processes Hidden in Operations Tab

    Posted 01-09-2018 04:37 PM

    Did a backup and did the update statement. The garbage is history. All good.