AnsweredAssumed Answered

integrity constraint (ACTIVITI.ACT_FK_EVENT_EXEC) violated - parent key not found

Question asked by ilyas_java on Dec 27, 2018

 

 

Hello,

 

Today, we faced this problem in production for the first time,

 

For information, i'm using version 6.0.0 of Activiti.

 

Below, the log messages:

 

 

Caused by: java.sql.SQLIntegrityConstraintViolationException : ORA-02291: integrity constraint (ACTIVITI.ACT_FK_EVENT_EXEC) violated - parent key not found

oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226)
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59)
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:910)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119)
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)
oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343)
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3887)
oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1079)
sun.reflect.GeneratedMethodAccessor122.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:498)
org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114)
com.sun.proxy.$Proxy203.execute(Unknown Source)
org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:46)
org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)
org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:185)
org.activiti.engine.impl.db.DbSqlSession.flushRegularInsert(DbSqlSession.java:649)
org.activiti.engine.impl.db.DbSqlSession.flushInsertEntities(DbSqlSession.java:544)
org.activiti.engine.impl.db.DbSqlSession.flushInserts(DbSqlSession.java:527)
org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:417)
org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:197)
org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:75)
org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:72)
org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47)
org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)
org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45)
org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:29)
org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:44)
org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:39)
org.activiti.engine.impl.asyncexecutor.ExecuteAsyncRunnable.executeJob(ExecuteAsyncRunnable.java:97)
org.activiti.engine.impl.asyncexecutor.ExecuteAsyncRunnable.run(ExecuteAsyncRunnable.java:75)
java.lang.Thread.run(Thread.java:748)
Caused by: oracle.jdbc.OracleDatabaseException : ORA-02291: integrity constraint (ACTIVITI.ACT_FK_EVENT_EXEC) violated - parent key not found

oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226)
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59)
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:910)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119)
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)
oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CP

 

 

Did anyone have an idea how to resolve this problem ?

Outcomes