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.

Prune activiti tables

sergiosoriaoliv

Hi guys

I 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 like removing some rows on it, is not affecting the app itself, but, I would like to know:

What is this table for?
Is there any way to configure activiti, so it cleans automatically data which is old or deprecated?

Thanks in advance

Sergio

Find more posts tagged with

Alfresco Process Services

Comments

dvuika

How that relates to ADF forum?

sergiosoriaoliv

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

eugenio_romano

Alfresco Process Services & Activiti (BPM) > Discussions

mdtabrezmca

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

ryandawson

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.