topic Re: CleanUp ACT_RU_* tables by hand in Alfresco Archive

CleanUp ACT_RU_* tables by hand

chimera — Tue, 12 May 2015 05:19:56 GMT

HiI 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 leg

Re: CleanUp ACT_RU_* tables by hand

martin_grofcik — Tue, 12 May 2015 05:46:38 GMT

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.

Regards
Martin

Re: CleanUp ACT_RU_* tables by hand

chimera — Tue, 12 May 2015 06:01:53 GMT

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

Re: CleanUp ACT_RU_* tables by hand

trademak — Wed, 13 May 2015 12:24:00 GMT

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,

Re: CleanUp ACT_RU_* tables by hand

chimera — Wed, 13 May 2015 12:25:49 GMT

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

Re: CleanUp ACT_RU_* tables by hand

martin_grofcik — Thu, 14 May 2015 07:15:05 GMT

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.


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

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

Regards
Martin