Removing activiti workflows in database by hand

[michalwrobel]

Because of the issue mentioned here: https://forums.alfresco.com/en/viewtopic.php?f=34&t=42709

I started to wonder how is it possible to remove finished (or even ongoing) process instances using SQL from activiti tables?
Just removing from act_hi_taskinst table doesn't work, giving some errors while starting server.

[jpotts]

Hitting the SQL tables to kill workflows sounds like a drastic step. Are you able to do what you need to do through the workflow console?

Jeff

[michalwrobel]

Yes, of course I've tried to undeploy process from console, that was the first thing I thought about, but it hadn't resolved the ""Error loading items"  share issue, so that's why I made for tampering with database manually.