Hi Team,
Am facing an issue for storing data, having more than 4000 Char…
SEVERE: ENGINE-16004 Exception while closing command context: ENGINE-03004 Exception while executing Database Operation ‘INSERT HistoricVariableInstanceEntity[1e63ed1c-98bf-11e7-91a1-005056b11dbe]’ with message ’
Error updating database. Cause: java.sql.SQLDataException: ORA-01401: inserted value too large for column
The error may involve org.camunda.bpm.engine.impl.persistence.entity.HistoricVariableInstanceEntity.insertHistoricVariableInstance-Inline
The error occurred while setting parameters
SQL: insert into ACT_HI_VARINST ( ID_, PROC_DEF_KEY_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TENANT_ID_, CASE_DEF_KEY_, CASE_DEF_ID_, CASE_INST_ID_, CASE_EXECUTION_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, BYTEARRAY_ID_, DOUBLE_, LONG_, TEXT_, TEXT2_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
Cause: java.sql.SQLDataException: ORA-01401: inserted value too large for column
'. Flush summary:
[
INSERT HistoricVariableInstanceEntity[1e63ed1c-98bf-11e7-91a1-005056b11dbe]
INSERT HistoricVariableInstanceEntity[1f062091-98bf-11e7-91a1-005056b11dbe]
INSERT HistoricVariableInstanceEntity[1f0c8939-98bf-11e7-91a1-005056b11dbe]
INSERT HistoricVariableInstanceEntity[1f0ed32e-98bf-11e7-91a1-005056b11dbe]
INSERT HistoricVariableInstanceEntity[1fb80b82-98bf-11e7-91a1-005056b11dbe]
INSERT HistoricVariableInstanceEntity[1fb80b84-98bf-11e7-91a1-005056b11dbe]
INSERT HistoricVariableInstanceEntity[1fb80b86-98bf-11e7-91a1-005056b11dbe]
INSERT HistoricVariableInstanceEntity[1fb80b88-98bf-11e7-91a1-005056b11dbe]
INSERT HistoricVariableInstanceEntity[1fb8329a-98bf-11e7-91a1-005056b11dbe]
INSERT HistoricVariableInstanceEntity[2039226d-98bf-11e7-91a1-005056b11dbe]
INSERT HistoricVariableInstanceEntity[203b6c63-98bf-11e7-91a1-005056b11dbe]
Can anyone please help me here.
Thanks & Regards,
Sudhanshu