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?
We are using version 5.22.