topic Re: Purge data from Activiti history tables in Alfresco Archive

Purge data from Activiti history tables

ganeshr — Mon, 28 Oct 2013 13:09:07 GMT

Hi, I have implemented workflow using Activiti, now the issue is the data in history table is growing larger as we have set the history level to full. We cannot set the history level to low, as we need the history data for generating reports. Is there a best way to purge the data from Activiti his

Re: Purge data from Activiti history tables

felipe1 — Mon, 28 Oct 2013 21:27:55 GMT

you could create a scheduled task that would backup the entire table and then delete data that was older than a certain treshold.

Example: every month the script would delete data older than 1 month.

Re: Purge data from Activiti history tables

abhinandan — Thu, 20 Nov 2014 10:32:28 GMT

Hi, the history documentation ( http://www.activiti.org/userguide/#historyConfig), says the following:
////
Since the DB contains historic entities for past as well as ongoing instances, you might want to consider querying these tables in order to minimize access to the runtime process instance data and that way keeping the runtime execution performant.
///

Should care be taken to make sure the scheduled job executes in the low/no traffic time to ensure there is no impact on the runtime execution performance. Is there a recommended partitioning strategy / purge frequency strategy that could be followed?

Re: Purge data from Activiti history tables

jbarrez — Fri, 05 Dec 2014 13:51:51 GMT

Yes, in the sense that any traffic on the database will impact performance of the other queries.

It's typically best practice to have data cleanups scheduled for the night or weekend I would guess.