AnsweredAssumed Answered

Clean up some ACT_GE_BYTEARRAY instances

Question asked by tim.whitworth on Nov 2, 2017
Latest reply on Nov 6, 2017 by cjose

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 the historical data is still needed for reporting purposes, so we can't just delete the historical tasks from java.

 

If we just delete the entries, we lose the ability to complete tasks with a nullpointer exception. If we delete the ACT_HI_VARINST entries pointing to them, we don't see any error, but it's not clear that no complication will emerge later.

 

Is there any means of clearing up just those entries? Or configuring the history system to ignore them?

 

We've recently upgraded to activiti 6.0.0, used with spring 4.2.5.

Outcomes