AnsweredAssumed Answered

CleanUp ACT_RU_* tables by hand

Question asked by chimera on May 12, 2015
Latest reply on May 14, 2015 by martin.grofcik
Hi

I overtook a project and upgraded to 5.16.4. I also noticed that the deleteProcessInstance method was never triggered by the previous developers at the end of a process. Thus the ACT_RU_* became fairly heavy.

I added that single-liner to the code, which is good, but of course still have all the legacy process run-time data. Deleting it, is tricky due to the numerous self-referencing foreign keys. Since this software is at Version 5.16.4 I'm certainly not the only one who is looking to compile such a SQL script. Of course, I know the executions to delete since I know the business key.

Anyone did compile that SQL Script before? Any default scripts from the Activiti Developers?

thanks

http://activiti.org/javadocs/org/activiti/engine/RuntimeService.html#deleteProcessInstance(java.lang.String, java.lang.String)

Outcomes