Hi all,
We need to delete old bytearray records but unfortunately the history tables have been purged before so we cannot establish connection between ACT_GE_BYTEARRAY and ACT_HI_PROCINST that way.
My idea is to filter the bytearrays belong to running instances via ACT_RU_VARIABLE. According to my current understanding this table contains process variables of primitive type.
Is it possible that there is no record belongs to a running instance in ACT_RU_VARIABLE but there is in ACT_GE_BYTEARRAY? So is it possible that a running process does not have primitive type variable only the type stored in ACT_GE_BYTEARRAY? In such a case we would delete bytearray records belonging to running instances which we want avoid of course.
BRs
Camunda documentation and support do not provide a recommended fail-proof solution for deleting old bytearray records.