topic Constraint violation when completing user task with timer in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/constraint-violation-when-completing-user-task-with-timer/m-p/96837#M66578 <HTML><HEAD></HEAD><BODY><SPAN>I have a main process calling another process multiple times using CallActivity with MultiInstance (sequentially).</SPAN><BR /><SPAN>The called process has (after other tasks) a User Task with a Boundary Timer (see attached image).</SPAN><BR /><BR /><SPAN>In my unit tests I have 2 unit tests doing exactly the same:</SPAN><BR /><SPAN>The main process calls the other process 5 times.</SPAN><BR /><SPAN>Each user task is assigned to a user and completed, so that it is going the succeeded path afterwards.</SPAN><BR /><BR /><SPAN>The first test is executed successfully.</SPAN><BR /><SPAN>The second test throws the following exception, when completing the user task of the first CallActivity: </SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />org.apache.ibatis.exceptions.PersistenceException: <BR />### Error updating database.&nbsp; Cause: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "ACT_FK_EXE_PROCINST: PUBLIC.ACT_RU_EXECUTION FOREIGN KEY(PROC_INST_ID_) REFERENCES PUBLIC.ACT_RU_EXECUTION(ID_)"; SQL statement:<BR />delete from ACT_RU_EXECUTION where ID_ = ? [23003-132]<BR />### The error may involve org.activiti.engine.impl.persistence.entity.ExecutionEntity.deleteExecution-Inline<BR />### The error occurred while setting parameters<BR />### Cause: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "ACT_FK_EXE_PROCINST: PUBLIC.ACT_RU_EXECUTION FOREIGN KEY(PROC_INST_ID_) REFERENCES PUBLIC.ACT_RU_EXECUTION(ID_)"; SQL statement:<BR />delete from ACT_RU_EXECUTION where ID_ = ? [23003-132]<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:120)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.delete(DefaultSqlSession.java:131)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession$DeleteById.execute(DbSqlSession.java:146)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.flushDeletes(DbSqlSession.java:444)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:349)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:147)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:103)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:49)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.TaskServiceImpl.complete(TaskServiceImpl.java:144)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; …<BR />Caused by: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "ACT_FK_EXE_PROCINST: PUBLIC.ACT_RU_EXECUTION FOREIGN KEY(PROC_INST_ID_) REFERENCES PUBLIC.ACT_RU_EXECUTION(ID_)"; SQL statement:<BR />delete from ACT_RU_EXECUTION where ID_ = ? [23003-132]<BR />&nbsp;&nbsp;&nbsp;at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)<BR />&nbsp;&nbsp;&nbsp;at org.h2.message.DbException.get(DbException.java:167)<BR />&nbsp;&nbsp;&nbsp;at org.h2.message.DbException.get(DbException.java:144)<BR />&nbsp;&nbsp;&nbsp;at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:374)<BR />&nbsp;&nbsp;&nbsp;at org.h2.constraint.ConstraintReferential.checkRowRefTable(ConstraintReferential.java:391)<BR />&nbsp;&nbsp;&nbsp;at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:271)<BR />&nbsp;&nbsp;&nbsp;at org.h2.table.Table.fireConstraints(Table.java:766)<BR />&nbsp;&nbsp;&nbsp;at org.h2.table.Table.fireAfterRow(Table.java:783)<BR />&nbsp;&nbsp;&nbsp;at org.h2.command.dml.Delete.update(Delete.java:79)<BR />&nbsp;&nbsp;&nbsp;at org.h2.command.CommandContainer.update(CommandContainer.java:70)<BR />&nbsp;&nbsp;&nbsp;at org.h2.command.Command.executeUpdate(Command.java:198)<BR />&nbsp;&nbsp;&nbsp;at org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:179)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:22)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:51)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:29)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:75)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:43)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:118)<BR />&nbsp;&nbsp;&nbsp;… 48 more<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>If I remove the BoundaryTimer, then everything works correctly.</SPAN><BR /><SPAN>Do you have any idea what's going wrong here?</SPAN></BODY></HTML> Wed, 08 Feb 2012 15:04:20 GMT capacia 2012-02-08T15:04:20Z Constraint violation when completing user task with timer https://connect.hyland.com/t5/alfresco-archive/constraint-violation-when-completing-user-task-with-timer/m-p/96837#M66578 I have a main process calling another process multiple times using CallActivity with MultiInstance (sequentially).The called process has (after other tasks) a User Task with a Boundary Timer (see attached image).In my unit tests I have 2 unit tests doing exactly the same:The main process calls the o Wed, 08 Feb 2012 15:04:20 GMT https://connect.hyland.com/t5/alfresco-archive/constraint-violation-when-completing-user-task-with-timer/m-p/96837#M66578 capacia 2012-02-08T15:04:20Z Re: Constraint violation when completing user task with timer https://connect.hyland.com/t5/alfresco-archive/constraint-violation-when-completing-user-task-with-timer/m-p/96838#M66579 <HTML><HEAD></HEAD><BODY><SPAN>Just noticed, that the error occurs, because the user task is completed at the same time as the boundary timer expires. If I complete the user task before the timer expires, then everything works find. </SPAN><BR /><SPAN>Can I do something to avoid this concurrency problem?</SPAN></BODY></HTML> Wed, 08 Feb 2012 15:40:27 GMT https://connect.hyland.com/t5/alfresco-archive/constraint-violation-when-completing-user-task-with-timer/m-p/96838#M66579 capacia 2012-02-08T15:40:27Z