topic Re: Maintenance Activiti Database in Alfresco Archive

Maintenance Activiti Database

fduartej — Thu, 31 Jul 2014 14:03:12 GMT

What is the best strategy to maintenance activiti database?Hi We are working with activiti for 1 year and now we have 50GB storage on the database and we want to maintenance this database in order to reduce the space used, we are checking some tables that we could reset this tables start with suffix

Re: Maintenance Activiti Database

sathish1 — Thu, 31 Jul 2014 18:28:36 GMT

Thinking retention policy will be based on organization needs. But one thing to keep in mind from, if there is a need to run reports based on the historic data, then it is better to push it to s dataware-house set-up before cleaning up the history information. Will follow the this thread if there are other recommendations.

Cheers.

Re: Maintenance Activiti Database

fduartej — Thu, 31 Jul 2014 22:46:09 GMT

I know it, but if we want to clean all historical data just should resest ACT_HI or if I clean it affect other component on activiti?

Re: Maintenance Activiti Database

martin_grofcik — Mon, 04 Aug 2014 09:53:19 GMT

Hi,

ACT_HI tables are used in reports and in activiti-crystalball simulation/debugger.
If you do not need reports and simulations you can archive them.

(test it first - it is just my guess)

Regards
Martin

Re: Maintenance Activiti Database

frederikherema1 — Wed, 06 Aug 2014 08:38:14 GMT

It's perfectly safe to delete/archive stuff from the ACT_HI_* tables, there are no foreign key constraints between history and runtime, nor between different history entities. Only make sure all entities belong to an ended process though (ACT_HI_PROCINST has an end-time).