topic integrity constraint (ACT_FK_EXE_PARENT) violated - parent key not found in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/integrity-constraint-act-fk-exe-parent-violated-parent-key-not/m-p/206962#M160092 <HTML><HEAD></HEAD><BODY><SPAN>Hello Activiti Team,</SPAN><BR /><BR /><SPAN>Today, we faced this problem in production for the first time and not get repeating. There are 2 ASync usertasks as part of my process. When userTask1 is completed, and during userTask2 creation time, got the exception as below and hence userTask2 is not persisted in database. Surprisingly, though parent execution is still persists in database, I got this exception. Generally parent execution entity(in ACT_RU_EXECUTION) row don't hold ACT_ID_ data. But surprisingly during debug, what I observed with parent execution record consists of userTask2 taskDefId in ACT_ID_ column. Can someone throw some light to debug further.</SPAN><BR /><SPAN>BTW, I am using activiti version 5.17 and ORACLE database.</SPAN><BR /><BR /><SPAN>Log messages goes here.</SPAN><BR /><SPAN style="color:blue;"><BR />15-Jun-2015[14:05:28.241]::ERROR:<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />ool-1-thread-103:<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />rg.activiti.engine.impl.jobexecutor.ExecuteJobsRunnable:96 - exception during job execution:<BR />### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (ACT_FK_EXE_PARENT) violated - parent key not found<BR />### The error may involve org.activiti.engine.impl.persistence.entity.ExecutionEntity.insertExecution-Inline<BR />### The error occurred while setting parameters<BR />### SQL: insert into ACT_RU_EXECUTION (ID_, REV_, PROC_INST_ID_, BUSINESS_KEY_, PROC_DEF_ID_, ACT_ID_, IS_ACTIVE_, IS_CONCURRENT_, IS_SCOPE_,IS_EVENT_SCOPE_, PARENT_ID_, SUPER_EXEC_, SUSPENSION_STATE_, CACHED_ENT_STATE_, TENANT_ID_, NAME_) values ( ?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )<BR />### Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (ACT_FK_EXE_PARENT) violated - parent key not found<BR />org.apache.ibatis.exceptions.PersistenceException:<BR />### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (ACT_FK_EXE_PARENT) violated - parent key not found<BR />### The error may involve org.activiti.engine.impl.persistence.entity.ExecutionEntity.insertExecution-Inline<BR />### The error occurred while setting parameters<BR />### SQL: insert into ACT_RU_EXECUTION (ID_, REV_, PROC_INST_ID_, BUSINESS_KEY_, PROC_DEF_ID_, ACT_ID_, IS_ACTIVE_, IS_CONCURRENT_, IS_SCOPE_,IS_EVENT_SCOPE_, PARENT_ID_, SUPER_EXEC_, SUSPENSION_STATE_, CACHED_ENT_STATE_, TENANT_ID_, NAME_) values ( ?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )<BR />### Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (ACT_FK_EXE_PARENT) violated - parent key not found<BR />at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)<BR />at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:147)<BR />at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:134)<BR />at org.activiti.engine.impl.db.DbSqlSession.flushInserts(DbSqlSession.java:761)<BR />at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:593)<BR />at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:211)<BR />at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:137)<BR />at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:66)<BR />at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47)<BR />at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:131)<BR />at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45)<BR />at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)<BR />at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)<BR />at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35)<BR />at org.activiti.engine.impl.jobexecutor.ExecuteJobsRunnable.handleMultipleJobs(ExecuteJobsRunnable.java:94)<BR />at org.activiti.engine.impl.jobexecutor.ExecuteJobsRunnable.run(ExecuteJobsRunnable.java:49)<BR />at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)<BR />at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)<BR />at java.lang.Thread.run(Thread.java:745)<BR />Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (ACT_FK_EXE_PARENT) violated - parent key not found<BR />at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)<BR />at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)<BR />at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)<BR />at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)<BR />at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)<BR />at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)<BR />at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)<BR />at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)<BR />at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)<BR />at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)<BR />at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3685)<BR />at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1376)<BR />at sun.reflect.GeneratedMethodAccessor92.invoke(Unknown Source)<BR />at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<BR />at java.lang.reflect.Method.invoke(Method.java:606)<BR />at oracle.ucp.jdbc.proxy.StatementProxyFactory.invoke(StatementProxyFactory.java:230)<BR />at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedStatementProxyFactory.java:124)<BR />at com.sun.proxy.$Proxy52.execute(Unknown Source)<BR />at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:41)<BR />at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:66)<BR />at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:45)<BR />at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:108)<BR />at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)<BR />at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:145)<BR />… 17 more <BR /></SPAN><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>Swamy.</SPAN></BODY></HTML> Tue, 16 Jun 2015 14:19:11 GMT swamy2156 2015-06-16T14:19:11Z integrity constraint (ACT_FK_EXE_PARENT) violated - parent key not found https://connect.hyland.com/t5/alfresco-archive/integrity-constraint-act-fk-exe-parent-violated-parent-key-not/m-p/206962#M160092 Hello Activiti Team,Today, we faced this problem in production for the first time and not get repeating. There are 2 ASync usertasks as part of my process. When userTask1 is completed, and during userTask2 creation time, got the exception as below and hence userTask2 is not persisted in database. Su Tue, 16 Jun 2015 14:19:11 GMT https://connect.hyland.com/t5/alfresco-archive/integrity-constraint-act-fk-exe-parent-violated-parent-key-not/m-p/206962#M160092 swamy2156 2015-06-16T14:19:11Z Re: integrity constraint (ACT_FK_EXE_PARENT) violated - parent key not found https://connect.hyland.com/t5/alfresco-archive/integrity-constraint-act-fk-exe-parent-violated-parent-key-not/m-p/206963#M160093 <HTML><HEAD></HEAD><BODY><SPAN>ACT_RU_EXECUTION table entry for parent execution as follows.(in CSV) for failed execution creation for the above.</SPAN><BR /><SPAN>"ID_","REV_","PROC_INST_ID_","BUSINESS_KEY_","PARENT_ID_","PROC_DEF_ID_","SUPER_EXEC_","ACT_ID_","IS_ACTIVE_","IS_CONCURRENT_","IS_SCOPE_","IS_EVENT_SCOPE_","SUSPENSION_STATE_","CACHED_ENT_STATE_","TENANT_ID_","NAME_","LOCK_TIME_"</SPAN><BR /><SPAN>"67c0eb05-1391-11e5-b698-020030001d11","3","67c0eb05-1391-11e5-b698-020030001d11","","","activiti_process:3:39d5e0f6-0479-11e5-aad9-020030001c46","","userTask2Def","1","0","1","0","1","0","","",""</SPAN><BR /></BODY></HTML> Tue, 16 Jun 2015 14:24:48 GMT https://connect.hyland.com/t5/alfresco-archive/integrity-constraint-act-fk-exe-parent-violated-parent-key-not/m-p/206963#M160093 swamy2156 2015-06-16T14:24:48Z Re: integrity constraint (ACT_FK_EXE_PARENT) violated - parent key not found https://connect.hyland.com/t5/alfresco-archive/integrity-constraint-act-fk-exe-parent-violated-parent-key-not/m-p/206964#M160094 <HTML><HEAD></HEAD><BODY><SPAN>Thanks for reporting the issue. But if it's not reproducible it's really hard to be able to solve this issue. If you know how to reproduce the issue or have more information about the context in which it happens we can look into it in more details.</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Wed, 17 Jun 2015 10:43:00 GMT https://connect.hyland.com/t5/alfresco-archive/integrity-constraint-act-fk-exe-parent-violated-parent-key-not/m-p/206964#M160094 trademak 2015-06-17T10:43:00Z