Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-10737

Exception while executing Batch Database Operation

XMLWordPrintable

    • Icon: Bug Report Bug Report
    • Resolution: Duplicate
    • Icon: L3 - Default L3 - Default
    • None
    • 7.10.0
    • engine
    • None
    • - camunda spring boot 3.2.1
      - spring boot 2.1.6.RELEASE
      - mssql jdbc 7.2.1.jre11

      We got this error with version :

      • camunda 7.10
      • camunda spring boot 3.2.1
      • spring boot 2.1.6.RELEASE
      • mssql jdbc 7.2.1.jre11
        org.camunda.bpm.engine.ProcessEngineException: 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.ExecutionEntity.deleteExecution (batch index #9) failed. 8 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: L'instruction DELETE est en conflit avec la contrainte SAME TABLE REFERENCE "ACT_FK_EXE_PARENT". Le conflit s'est produit dans la base de données "rec_mdsa397_amp_signature_service", table "dbo.ACT_RU_EXECUTION", column 'PARENT_ID_'.
        ### Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.deleteExecution (batch index #9) failed. 8 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: L'instruction DELETE est en conflit avec la contrainte SAME TABLE REFERENCE "ACT_FK_EXE_PARENT". Le conflit s'est produit dans la base de données "rec_mdsa397_amp_signature_service", table "dbo.ACT_RU_EXECUTION", column 'PARENT_ID_'.
        java.sql.BatchUpdateException: L'instruction DELETE est en conflit avec la contrainte SAME TABLE REFERENCE "ACT_FK_EXE_PARENT". Le conflit s'est produit dans la base de données "rec_mdsa397_amp_signature_service", table "dbo.ACT_RU_EXECUTION", column 'PARENT_ID_'.
        '. Flush summary: 
         [
          INSERT VariableInstanceEntity[cf5a8013-91df-11e9-a83e-005056ba6ed3]
          INSERT VariableInstanceEntity[cf5a8016-91df-11e9-a83e-005056ba6ed3]
          INSERT VariableInstanceEntity[cf5a8018-91df-11e9-a83e-005056ba6ed3]
          INSERT VariableInstanceEntity[cf5a801a-91df-11e9-a83e-005056ba6ed3]
          INSERT VariableInstanceEntity[cf5a801c-91df-11e9-a83e-005056ba6ed3]
          INSERT VariableInstanceEntity[cf5af550-91df-11e9-a83e-005056ba6ed3]
          INSERT VariableInstanceEntity[cf5b1c61-91df-11e9-a83e-005056ba6ed3]
          INSERT VariableInstanceEntity[cf5b1c62-91df-11e9-a83e-005056ba6ed3]
          INSERT VariableInstanceEntity[cf5b1c64-91df-11e9-a83e-005056ba6ed3]
          INSERT VariableInstanceEntity[cf5b1c65-91df-11e9-a83e-005056ba6ed3]
          INSERT VariableInstanceEntity[cf5b6a89-91df-11e9-a83e-005056ba6ed3]
          INSERT VariableInstanceEntity[cf5b6a8f-91df-11e9-a83e-005056ba6ed3]
          INSERT VariableInstanceEntity[cf5b91a0-91df-11e9-a83e-005056ba6ed3]
          INSERT VariableInstanceEntity[cf5b91a1-91df-11e9-a83e-005056ba6ed3]
          INSERT VariableInstanceEntity[cf5b91a3-91df-11e9-a83e-005056ba6ed3]
          INSERT VariableInstanceEntity[cf5b91a4-91df-11e9-a83e-005056ba6ed3]
          INSERT VariableInstanceEntity[cf5c54f8-91df-11e9-a83e-005056ba6ed3]
          INSERT EventSubscriptionEntity[cf5b6a8b-91df-11e9-a83e-005056ba6ed3]
          INSERT EventSubscriptionEntity[cf5c7c0a-91df-11e9-a83e-005056ba6ed3]
          DELETE MessageEntity[cf15133a-91df-11e9-a83e-005056ba6ed3]
          UPDATE VariableInstanceEntity[12898ead-91df-11e9-a83e-005056ba6ed3]
          DELETE VariableInstanceEntity[11d707c5-91df-11e9-a83e-005056ba6ed3]
          DELETE VariableInstanceEntity[11d72ed6-91df-11e9-a83e-005056ba6ed3]
          DELETE VariableInstanceEntity[11d72ed7-91df-11e9-a83e-005056ba6ed3]
          DELETE VariableInstanceEntity[11d72eda-91df-11e9-a83e-005056ba6ed3]
          DELETE VariableInstanceEntity[11d72edc-91df-11e9-a83e-005056ba6ed3]
          DELETE VariableInstanceEntity[11d72ede-91df-11e9-a83e-005056ba6ed3]
          DELETE VariableInstanceEntity[11d72ee0-91df-11e9-a83e-005056ba6ed3]
          DELETE VariableInstanceEntity[ce7b6b2e-91df-11e9-a83e-005056ba6ed3]
          DELETE VariableInstanceEntity[ce7b6b2f-91df-11e9-a83e-005056ba6ed3]
          DELETE VariableInstanceEntity[ce7b9241-91df-11e9-a83e-005056ba6ed3]
          DELETE VariableInstanceEntity[ce7b9247-91df-11e9-a83e-005056ba6ed3]
          DELETE VariableInstanceEntity[ce7b9248-91df-11e9-a83e-005056ba6ed3]
          DELETE VariableInstanceEntity[ce7b9249-91df-11e9-a83e-005056ba6ed3]
          DELETE VariableInstanceEntity[ce7b924a-91df-11e9-a83e-005056ba6ed3]
          DELETE VariableInstanceEntity[ce7bb95d-91df-11e9-a83e-005056ba6ed3]
          DELETE VariableInstanceEntity[cf1476f6-91df-11e9-a83e-005056ba6ed3]
          DELETE ByteArrayEntity[12252768-91df-11e9-a83e-005056ba6ed3]
          DELETE ByteArrayEntity[ce7c2e92-91df-11e9-a83e-005056ba6ed3]
          DELETE ByteArrayEntity[ce7c7cb4-91df-11e9-a83e-005056ba6ed3]
          DELETE_BULK deleteByteArrayNoRevisionCheck cf3c236b-91df-11e9-a83e-005056ba6ed3
          UPDATE ExecutionEntity[0e452e87-91df-11e9-a83e-005056ba6ed3]
          DELETE ExecutionEntity[11d72ed8-91df-11e9-a83e-005056ba6ed3]
          DELETE ExecutionEntity[ce7b6b2d-91df-11e9-a83e-005056ba6ed3]
          DELETE ExecutionEntity[ce7af5fb-91df-11e9-a83e-005056ba6ed3]
          DELETE ExecutionEntity[11d8195c-91df-11e9-a83e-005056ba6ed3]
          DELETE ExecutionEntity[11d72ed9-91df-11e9-a83e-005056ba6ed3]
          DELETE ExecutionEntity[11d6e0b3-91df-11e9-a83e-005056ba6ed3]
          UPDATE HistoricActivityInstanceEventEntity[11d6e0b4-91df-11e9-a83e-005056ba6ed3]
          UPDATE HistoricActivityInstanceEventEntity[SubProcess_164wi1g:11d8195d-91df-11e9-a83e-005056ba6ed3]
        ]
        	at org.camunda.bpm.engine.impl.db.EnginePersistenceLogger.flushDbOperationsException(EnginePersistenceLogger.java:692)
        	at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperations(DbEntityManager.java:361)
        	at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperationManager(DbEntityManager.java:324)
        	at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flush(DbEntityManager.java:296)
        	at org.camunda.bpm.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:207)
        	at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:136)
        	at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:115)
        	at org.camunda.bpm.engine.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:45)
        	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
        	at org.camunda.bpm.engine.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:43)
        	at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:69)
        	at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:32)
        	at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobHelper.executeJob(ExecuteJobHelper.java:50)
        	at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobHelper.executeJob(ExecuteJobHelper.java:43)
        	at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobsRunnable.executeJob(ExecuteJobsRunnable.java:91)
        	at org.camunda.bpm.engine.impl.jobexecutor.ExecuteJobsRunnable.run(ExecuteJobsRunnable.java:60)
        	at org.springframework.cloud.sleuth.instrument.async.TraceRunnable.run(TraceRunnable.java:67)
        	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
        	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
        	at java.base/java.lang.Thread.run(Thread.java:834)
        Caused by: org.apache.ibatis.exceptions.PersistenceException: 
        ### Error flushing statements.  Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.deleteExecution (batch index #9) failed. 8 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: L'instruction DELETE est en conflit avec la contrainte SAME TABLE REFERENCE "ACT_FK_EXE_PARENT". Le conflit s'est produit dans la base de données "rec_mdsa397_amp_signature_service", table "dbo.ACT_RU_EXECUTION", column 'PARENT_ID_'.
        ### Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.deleteExecution (batch index #9) failed. 8 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: L'instruction DELETE est en conflit avec la contrainte SAME TABLE REFERENCE "ACT_FK_EXE_PARENT". Le conflit s'est produit dans la base de données "rec_mdsa397_amp_signature_service", table "dbo.ACT_RU_EXECUTION", column 'PARENT_ID_'.
        	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
        	at org.apache.ibatis.session.defaults.DefaultSqlSession.flushStatements(DefaultSqlSession.java:255)
        	at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.flushOperations(DbSqlSession.java:90)
        	at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperations(DbEntityManager.java:356)
        	... 18 more
        Caused by: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.deleteExecution (batch index #9) failed. 8 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: L'instruction DELETE est en conflit avec la contrainte SAME TABLE REFERENCE "ACT_FK_EXE_PARENT". Le conflit s'est produit dans la base de données "rec_mdsa397_amp_signature_service", table "dbo.ACT_RU_EXECUTION", column 'PARENT_ID_'.
        	at org.apache.ibatis.executor.BatchExecutor.doFlushStatements(BatchExecutor.java:146)
        	at org.apache.ibatis.executor.BaseExecutor.flushStatements(BaseExecutor.java:129)
        	at org.apache.ibatis.executor.BaseExecutor.flushStatements(BaseExecutor.java:122)
        	at org.apache.ibatis.executor.CachingExecutor.flushStatements(CachingExecutor.java:114)
        	at org.apache.ibatis.session.defaults.DefaultSqlSession.flushStatements(DefaultSqlSession.java:253)
        	... 20 more
        Caused by: java.sql.BatchUpdateException: L'instruction DELETE est en conflit avec la contrainte SAME TABLE REFERENCE "ACT_FK_EXE_PARENT". Le conflit s'est produit dans la base de données "rec_mdsa397_amp_signature_service", table "dbo.ACT_RU_EXECUTION", column 'PARENT_ID_'.
        	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:2083)
        	at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:128)
        	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java)
        	at org.apache.ibatis.executor.BatchExecutor.doFlushStatements(BatchExecutor.java:122)
        	... 24 more
        

      It's a multi-instance call activity without any asynchronous option.

        This is the controller panel for Smart Panels app

              tassilo.weidner Tassilo Weidner
              JohnDoe John Doe
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: