topic Re: Clean up some ACT_GE_BYTEARRAY instances in Alfresco Forum

Clean up some ACT_GE_BYTEARRAY instances

tim_whitworth — Thu, 02 Nov 2017 10:39:00 GMT

We've been storing a copy of the main entity for our operations in a workflow variable, which has resulted in a buildup of data in the ACT_GE_BYTEARRAY as hist.var-entity, along with hist.var-child_entity and hist.var-workflowDefinition.What should I do to make it safe to delete these? The rest of t

Re: Clean up some ACT_GE_BYTEARRAY instances

afaust — Mon, 06 Nov 2017 10:40:42 GMT

I would say deleting any data from an active process is inherently unsafe. I would restrict your deletions to variables / byte arrays from processes that have already terminated. And you should only delete byte arrays referenced from actual variables - workflow definitions / deployments and such should only be deleted by using the Activiti APIs for "undeploying" them.

What I always recommend my customers to consider is that any historical data that may be relevant for reporting be exported in some sorts, so the process engine tables can be cleared out frequently. For a few customer processes, this was done by simply generating a report PDF as the last service task in the process, and filing that to Alfresco (in the embedded Activiti use case) or on an archive system. Alternatively, the data might be exported to a different database / schema which would be more suitable for reporting / BI views than the BPM engine schema. Once exported, the entire process and its associated data can be deleted after completion.

Re: Clean up some ACT_GE_BYTEARRAY instances

cjose — Mon, 06 Nov 2017 17:57:45 GMT

Also, going forward, transient variables (Activiti User Guide - Transient Variables) introduced in Activiti V6 might be a good candidate for your use case.