Hi I am unable to delete a deployment when i pass deployment id and it is giving below exception
processeng.getRepositoryService()
.deleteDeployment(wfDef.getExternalId(), true);
ENGINE-16004 Exception while closing command context: An exception occurred in the persistence layer. Please check the server logs for a detailed message and the entire exception stack trace.:
org.camunda.bpm.engine.ProcessEngineException: An exception occurred in the persistence layer. Please check the server logs for a detailed message and the entire exception stack trace.
at org.camunda.bpm.engine.impl.util.ExceptionUtil.wrapPersistenceException(ExceptionUtil.java:263)
at org.camunda.bpm.engine.impl.db.EnginePersistenceLogger.flushDbOperationException(EnginePersistenceLogger.java:133)
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperations(DbEntityManager.java:364)
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperationManager(DbEntityManager.java:323)
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flush(DbEntityManager.java:295)
at org.camunda.bpm.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:272)
at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:188)
at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:119)
at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70)
at org.camunda.bpm.engine.impl.interceptor.CommandCounterInterceptor.execute(CommandCounterInterceptor.java:35)
at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
at org.camunda.bpm.engine.impl.RepositoryServiceImpl.deleteDeployment(RepositoryServiceImpl.java:116)
Caused by: org.camunda.bpm.engine.ProcessEngineException: ENGINE-03004 Exception while executing Database Operation ‘DELETE_BULK deleteHistoricJobLogByProcessDefinitionId abcworkflow:1:64188’ with message ’
Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.HistoricJobLogEntity.deleteHistoricJobLogByProcessDefinitionId (batch index #14) failed. 13 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: ORA-12838: cannot read/modify an object after modifying it in parallel
Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.HistoricJobLogEntity.deleteHistoricJobLogByProcessDefinitionId (batch index #14) failed. 13 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: ORA-12838: cannot read/modify an object after modifying it in parallel
java.sql.BatchUpdateException: ORA-12838: cannot read/modify an object after modifying it in parallel
java.sql.SQLException: ORA-12838: cannot read/modify an object after modifying it in parallel
'. Flush summary:
[
DELETE_BULK deleteIdentityLinkByProcDef campaign:1:64188
DELETE_BULK deleteExceptionByteArraysByIds {deploymentId=64186}
DELETE_BULK deleteExceptionByteArraysByIds {processDefinitionId=campaign:1:64188}
DELETE_BULK deleteCaseDefinitionsByDeploymentId 64186
DELETE_BULK deleteDecisionDefinitionsByDeploymentId 64186
DELETE_BULK deleteDecisionRequirementsDefinitionsByDeploymentId 64186
DELETE_BULK deleteProcessDefinitionsById campaign:1:64188
DELETE_BULK deleteResourcesByDeploymentId 64186
DELETE_BULK deleteDeployment 64186
DELETE_BULK deleteCamundaFormDefinitionsByDeploymentId 64186
DELETE_BULK deleteHistoricIdentityLinksByProcessDefinitionId campaign:1:64188
DELETE_BULK deleteHistoricIncidentsByProcessDefinitionId campaign:1:64188
DELETE_BULK deleteHistoricJobLogByDeploymentId 64186
DELETE_BULK deleteHistoricJobLogByProcessDefinitionId campaign:1:64188
DELETE_BULK deleteJobDefinitionsByProcessDefinitionId campaign:1:64188
]
at org.camunda.bpm.engine.impl.db.EnginePersistenceLogger.flushDbOperationException(EnginePersistenceLogger.java:132)
… 20 common frames omitted
Caused by: org.apache.ibatis.exceptions.PersistenceException:
Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.HistoricJobLogEntity.deleteHistoricJobLogByProcessDefinitionId (batch index #14) failed. 13 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: ORA-12838: cannot read/modify an object after modifying it in parallel
Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.HistoricJobLogEntity.deleteHistoricJobLogByProcessDefinitionId (batch index #14) failed. 13 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: ORA-12838: cannot read/modify an object after modifying it in parallel
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at org.apache.ibatis.session.defaults.DefaultSqlSession.flushStatements(DefaultSqlSession.java:254)
at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.flushBatchOperations(DbSqlSession.java:444)
at org.camunda.bpm.engine.impl.db.sql.BatchDbSqlSession.executeDbOperations(BatchDbSqlSession.java:74)
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperations(DbEntityManager.java:341)
... 19 common frames omitted
Caused by: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.HistoricJobLogEntity.deleteHistoricJobLogByProcessDefinitionId (batch index #14) failed. 13 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: ORA-12838: cannot read/modify an object after modifying it in parallel
at org.apache.ibatis.executor.BatchExecutor.doFlushStatements(BatchExecutor.java:149)
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:252)
... 22 common frames omitted
Caused by: java.sql.BatchUpdateException: ORA-12838: cannot read/modify an object after modifying it in parallel