We are trying to delete tasks from runtime tables. Act_ru_task, execution and act_ru_variable tables. We want to be able to leave the process definition as is. We havr about 70000 tasks that we want to delete.
We tried the following options
1. Delete deployment API. This API is running for more than 3 hrs. We see a lot of exceptions. As old tasks are deleted, new tasks get created.
2. The direct sql way. After deleting data from the tables, everything stopped working. We deleted data from act evt log, identity link, ru tables and re tables. We are not sure of the order of deleting data from the tables directly. Any ideas?
Currently our application connect with only one database. As part of enhanced architecture, we are expanding to put workflows into multiple database s. The reason for deletion is to have only the workflow tasks for specific processes in a database. Which workflow processes to create iniwhich database is driven by aaconfig table. We are trying to get a one time purge of unwanted data.