Solution for issue ENGINE-03004: value too long for type character varying(4000)

[charlands]

Hello,

I’m quite new with Camunda. We have an issue when the data is saved (historic table - PostgreSQL)

ENGINE-03004 Exception while executing Database Operation 'INSERT HistoricVariableInstanceEntity[389997] → was aborted: ERROR: value too long for type character varying(4000)

Caused by: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.HistoricVariableInstanceEntity.insertHistoricVariableInstance (batch index #1) failed. Cause: java.sql.BatchUpdateException: Batch entry 1 insert into ACT_HI_VARINST (

I’m wondering what’s the best solution for this. Is it possible to change the type of the column (e.g. text)? Is there another option?

Thanks!

[cma]

Hi @charlands, we changed the type of the column to text and never encountered any issues, but it was on a mysql database. You also need to change the active variable instance table not just the historic one.

[charlands]

Good to know Thanks for the quick answer!