I 've created a process variable of type json via camForm function and I would like to read its value (like I do in Cockpit) in the ACT_GE_BYTEARRAY table of default H2 database.
The issue is that the values there are stored as BYTES and so they aren’t readable by a human.
Does anyone know please if and how can I decode them so as to being human-readable?
Thats hard to say without knowing your setup. You probably have history level set to full and the “duplicates” come from hi_varinst. Just check where the respective bytearray_id is referenced. Usual suspects are ACT_RU_VARIABLE, ACT_HI_VARINST, ACT_HI_DETAIL, ACT_HI_DEC_IN, ACT_HI_DEC_OUT.
I don’t think there is any problem there.
You should usually search the other way round, i.e. get the variable (of the execution/…) you are interested in, then look in the referenced byte array. If you don’t want to understand the internal data structures - which you need not - it might be easier to use the REST API to explore your instances.