Input parameter of type text cannot have 4k+ character

[vishnukumar_gr]

Hi,

I have an external service-task to get input parameter as text. This parameter value is received via element-template textarea. If this text is 4k+ character and handle this in payload, the service task throws exception “### Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.HistoricVariableInstanceEntity.insertHistoricVariableInstance (batch index #1) failed. Cause: java.sql.BatchUpdateException”

How to avoid this exception?

-Vishnu

[aravindhrs]

@vishnukumar_gr, process variables has char limit to 4k. If your variables exceeds this limit you have to send your process variable as a serialized object or byteArray(ByteArrays are stored as large object types) to the engine.

Error while starting process instance

@Sandeep_Yalamarthi you’re storing the payload as json string in the process variable. But the payload size exceeds varchar(4000), so it fails with exception was aborted: ERROR: value too long for type character varying(4000) Call getNextException to see other errors in the batch. Alternatively, you can store this payload as an object.

[vishnukumar_gr]

@aravindhrs the value is fetched from camunda:inputparameter “Text” type. Also, the value is internally changed as spin object S(value) in the payload for making API request. But the problem is with the “Textarea” where it could not get the large value. Is there a way to get the textarea value as it is with more no. of characters?