IT Process Automation

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?

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

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.

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. 

So delete from C2ORuntimeObjectsARCH where RunState = 'Inactive'?

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

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

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.  

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