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


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?


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.

Good to know :slight_smile: Thanks for the quick answer!

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.