SQL integrity constraint errors in batch processes

Camunda 7 Topics Discussion & Questions
1

Hi together,

in our Camunda engine we have a strange error message. First I thought it could be a problem in our own code but it looks more like a Camunda issue.

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.VariableInstanceEntity.deleteByteArray (batch index #3) failed. 2 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: ORA-02292: integrity constraint (CROSS_PRC.ACT_FK_JOB_EXCEPTION) violated - child record found\ Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.VariableInstanceEntity.deleteByteArray (batch index #3) failed. 2

Has anyone faced a similar error message and knows what’s the root cause of this problem?

The problems occurs in one of our batch processes which alter some process instance variables of running processes.

We use Camunda process engine 7.10.

Thanks in advance!

2

Hi @Chris,

Can you provide more details when the problem occurs and steps to reproduce it, or an example that reproduces the problem?

It would also help if you can provide the Oracle DB version, together with the JDBC and JDK versions. The wrong combinations have been known to result in incorrect Process Engine behavior.

Best,
Nikola

3