Unusual error

Camunda 7 Topics Discussion & Questions
1

Hi all,

I got the following error while working on my camunda workflow. It is basically calling certain services and is a series connection of service tasks.
i have implemeted service calls using connectors and expressions. When i configured another activity there as a service task, i got the following error.

The process could not be started. : Cannot instantiate process definition rejectionActivity:27:fb0267db-cb37-11ea-9fcc-005056914fc1: ENGINE-03083 Exception while executing Batch Database Operations with message ’ ### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.HistoricVariableInstanceEntity.insertHistoricVariableInstance (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-12899: waarde te groot voor kolom “CEH_OWNER”.“RCC_ACT_HI_VARINST”.“TEXT_” (huidige waarde: 2801, maximumwaarde: 2000) ### Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.HistoricVariableInstanceEntity.insertHistoricVariableInstance (batch index #1) failed. Cause: java.sql.BatchUpdateException: ORA-12899: waarde te groot voor kolom “CEH_OWNER”.“RCC_ACT_HI_VARINST”.“TEXT_” (huidige waarde: 2801, maximumwaarde: 2000) java.sql.BatchUpdateException: ORA-12899: waarde te groot voor kolom “CEH_OWNER”.“RCC_ACT_HI_VARINST”.“TEXT_” (huidige waarde: 2801, maximumwaarde: 2000) java.sql.SQLException: ORA-12899: waarde te groot voor kolom “CEH_OWNER”.“RCC_ACT_HI_VARINST”.“TEXT_” (huidige waarde: 2801, maximumwaarde: 2000) '. Flush summary: [ INSERT HistoricVariableInstanceEntity[c723b411-cb41-11ea-9fcc-005056914fc1] INSERT HistoricVariableInstanceEntity[c723b412-cb41-11ea-9fcc-005056914fc1] INSERT HistoricVariableInstanceEntity[c772494a-cb41-11ea-9fcc-005056914fc1] INSERT HistoricVariableInstanceEntity[c77ef37f-cb41-11ea-9fcc-005056914fc1] INSERT HistoricVariableInstanceEntity[c78e35c1-cb41-11ea-9fcc-005056914fc1] INSERT HistoricVariableInstanceEntity[c79317c3-cb41-11ea-9fcc-005056914fc1] INSERT HistoricVariableInstanceEntity[c7a08546-cb41-11ea-9fcc-005056914fc1] INSERT HistoricVariableUpdateEventEntity[c7240236-cb41-11ea-9fcc-005056914fc1] INSERT HistoricVariableUpdateEventEntity[c7240237-cb41-11ea-9fcc-005056914fc1] INSERT HistoricVariableUpdateEventEntity[c772494c-cb41-11ea-9fcc-005056914fc1] INSERT HistoricVariableUpdateEventEntity[c77ef380-cb41-11ea-9fcc-005056914fc1] INSERT HistoricVariableUpdateEventEntity[c78e35c2-cb41-11ea-9fcc-005056914fc1] INSERT HistoricVariableUpdateEventEntity[c79317c4-cb41-11ea-9fcc-005056914fc1] INSERT HistoricVariableUpdateEventEntity[c7a08547-cb41-11ea-9fcc-005056914fc1] INSERT HistoricTaskInstanceEventEntity[c7a0854a-cb41-11ea-9fcc-005056914fc1] INSERT HistoricProcessInstanceEventEntity[c723b40f-cb41-11ea-9fcc-005056914fc1] INSERT HistoricFormPropertyEventEntity[c7240233-cb41-11ea-9fcc-005056914fc1] INSERT HistoricFormPropertyEventEntity[c7240235-cb41-11ea-9fcc-005056914fc1] INSERT HistoricActivityInstanceEventEntity[Activity_02tgl3d:c7a08548-cb41-11ea-9fcc-005056914fc1] INSERT HistoricActivityInstanceEventEntity[Activity_04ahd8n:c7242948-cb41-11ea-9fcc-005056914fc1] INSERT HistoricActivityInstanceEventEntity[Activity_0fqfccd:c7a08549-cb41-11ea-9fcc-005056914fc1] INSERT HistoricActivityInstanceEventEntity[Activity_15dgggd:c772705e-cb41-11ea-9fcc-005056914fc1] INSERT HistoricActivityInstanceEventEntity[Activity_1v9mdij:c79317c5-cb41-11ea-9fcc-005056914fc1] INSERT HistoricActivityInstanceEventEntity[StartEvent_1:c723b410-cb41-11ea-9fcc-005056914fc1] INSERT ExecutionEntity[c723b40f-cb41-11ea-9fcc-005056914fc1] INSERT TaskEntity[c7a0854a-cb41-11ea-9fcc-005056914fc1] INSERT ByteArrayEntity[c7724949-cb41-11ea-9fcc-005056914fc1] INSERT ByteArrayEntity[c772494b-cb41-11ea-9fcc-005056914fc1] INSERT ByteArrayEntity[c772494d-cb41-11ea-9fcc-005056914fc1] INSERT VariableInstanceEntity[c723b411-cb41-11ea-9fcc-005056914fc1] INSERT VariableInstanceEntity[c723b412-cb41-11ea-9fcc-005056914fc1] INSERT VariableInstanceEntity[c772494a-cb41-11ea-9fcc-005056914fc1] INSERT VariableInstanceEntity[c77ef37f-cb41-11ea-9fcc-005056914fc1] INSERT VariableInstanceEntity[c78e35c1-cb41-11ea-9fcc-005056914fc1] INSERT VariableInstanceEntity[c79317c3-cb41-11ea-9fcc-005056914fc1] INSERT VariableInstanceEntity[c7a08546-cb41-11ea-9fcc-005056914fc1] ]

i am kinda clueless about how or why this error occured, pardon me as i cannot share the bpmn diagram with the forum. But i can tell you that i removed the service task with expression implementation and then was able to run the process without error.

Thanks in advance

2

Hi @prateek_gulati,

your string value is too large for the database.

You should store it as an object, the engine will put the value into a blob table and you don’t need to care about the size anymore: Process Variables | docs.camunda.org

Hope this helps, Ingo

1 Like
3

Thanks @Ingo_Richtsmeier
What you suggested is a great resource but i’m a little stuck at figuring out how to convert it into an object using javascript, did not find any syntax regarding that. I am getting the response as a part of a connector and need to use script implementation to achieve object conversion. Any help would be great.