topic Re: Prune activiti tables in Alfresco Forum

Prune activiti tables

sergiosoriaoliv — Fri, 13 Jul 2018 15:59:45 GMT

Hi guysI just joined a project, using activiti 5 and drools, which is getting a really huge DB.The point is, almost 70% of the data is on act_ru_identitilink. It looks like this table is part of the core of the activity, but I cannot see how this table got 60GB size. I was playing with it, and looks

Re: Prune activiti tables

dvuika — Mon, 16 Jul 2018 06:56:46 GMT

How that relates to ADF forum?

Re: Prune activiti tables

sergiosoriaoliv — Mon, 16 Jul 2018 07:01:52 GMT

I see... what could be the proper forum then? Am I able to move it by myself? If not, please, any moderator, be my guest

Re: Prune activiti tables

eugenio_romano — Tue, 17 Jul 2018 14:25:35 GMT

Alfresco Process Services & Activiti (BPM) > Discussions

Re: Prune activiti tables

mdtabrezmca — Wed, 18 Jul 2018 04:53:05 GMT

Hi,

I see you are looking for archive and purge. activiti 6 has activiti-admin.war app which lists all the process instances and task so that you can list and delete the proces instances.

This table act_ru_identitilink is storing information about identity links. for more details use this link in activiti user guide Activiti User Guide

Re: Prune activiti tables

ryandawson — Wed, 18 Jul 2018 13:41:45 GMT

Just to add to this, basically ACT_RU_IDENTITYLINK records all the relationships from tasks to users or groups, including which users/groups are candidates for a task or which are involved. Before you look at pruning this table you should check whether the tasks have completed (see

ACT_HI_TASKINST and ACT_RU_TASK) and whether you still need that data.