Value too large for column “CAMUNDA_PROD”.”ACT_HI_VARINST”.”TEXT_”

[Afjal_Ansari]

Value too large for column “CAMUNDA_PROD”.”ACT_HI_VARINST”.”TEXT_”Value too large for column “CAMUNDA_PROD”.”ACT_HI_VARINST”.”TEXT_”Value too large for column “CAMUNDA_PROD”.”ACT_HI_VARINST”.”TEXT_”

[rangaswamyd25]

Hi @Afjal_Ansari ,
refer this related thread for more info

Value too large for column "CAMUNDA_PROD"."ACT_HI_VARINST"."TEXT_"

@rlehnert You’re encountering the “Value too large for column” error because Camunda 7.9.0 tries to store a variable’s value (typically a String or serialized object) in the ACT_HI_VARINST.TEXT_ column, which is limited to 2000 characters (bytes) in Oracle due to NVARCHAR2(2000). Root Cause: In Camunda 7.9.0: If a variable value is short (<= 2000 characters), it is stored in the TEXT_ column. If it exceeds the size, it should be stored in the BYTEARRAY_ column via the ACT_GE_BYTEARRAY t…