nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

CleanUp ACT_RU_* tables by hand

chimera

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)

Find more posts tagged with

Comments

martin_grofcik

Hi,

I would not delete anything from the runtime tables. There is no need to delete process instance by

deleteProcessInstance{/code] method. Activiti stores runtime data in RU tables. When process is finished there is no record in the RU tables.<br><br>Regards<br>Martin

chimera

Ok. So that is done automatically if the process ends. Making sense. Besides the programm/process logic treatment, is there still a SQL script to delete interrupted or failed process execution data that is no longer required? In particular for Integration or any testing environment that would be helpful.

@Martin, I think we need to bump for a beer. You are working just around the corner from my working location

trademak

We don't have such a script.
We do have a way to cleanup the whole database for our unit tests, but I don't know if that's what you are looking for.

Best regards,

chimera

Presumably a subset of this cleanup is what we are looking for. Is that accessible on versioning system? Thank you.

martin_grofcik

Hi Chimera,

is there still a SQL script to delete interrupted or failed process execution data that is no longer required?

SQL script no. There is API in the RuntimeService.

<br>&nbsp; /**<br>&nbsp;&nbsp; * Delete an existing runtime process instance.<br>&nbsp;&nbsp; * <br>&nbsp;&nbsp; * @param processInstanceId<br>&nbsp;&nbsp; *&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; id of process instance to delete, cannot be null.<br>&nbsp;&nbsp; * @param deleteReason<br>&nbsp;&nbsp; *&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reason for deleting, can be null.<br>&nbsp;&nbsp; * @throws ActivitiObjectNotFoundException<br>&nbsp;&nbsp; *&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; when no process instance is found with the given id.<br>&nbsp;&nbsp; */<br>&nbsp; void deleteProcessInstance(String processInstanceId, String deleteReason);<br>

Beer: yes sure next time when I'll be in Bern.

Regards
Martin