topic SQLIntegrityConstraintViolationException when completing User task in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/sqlintegrityconstraintviolationexception-when-completing-user/m-p/164855#M118574 <HTML><HEAD></HEAD><BODY><SPAN>Facing SQLIntegrityConstraintViolationException when completing the first user task in business process. Developed business process with two human task(both exclusive) and when completing the first task getting the below exception. Business process is simple start event -&gt; user task1 -&gt; user task2 -&gt; end event.</SPAN><BR /><BR /><BR /><BR /><SPAN>26-Mar-2014[08:25:35.758]:<img id="smileyvery-happy" class="emoticon emoticon-smileyvery-happy" src="https://connect.hyland.com/i/smilies/16x16_smiley-very-happy.png" alt="Smiley Very Happy" title="Smiley Very Happy" />EBUG::listenerContainer-2:<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.persistence.entity.VariableInstanceEntity.deleteVariableInstance:47 - ooo Using Connection [Transaction-aware proxy for target Connection [jdbc<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />racle:thin:@//DO4501.oracle.uprr.com:1521/DO45.uprr.com, UserName=DBPE999, Oracle JDBC driver]]</SPAN><BR /><SPAN>26-Mar-2014[08:25:35.758]:<img id="smileyvery-happy" class="emoticon emoticon-smileyvery-happy" src="https://connect.hyland.com/i/smilies/16x16_smiley-very-happy.png" alt="Smiley Very Happy" title="Smiley Very Happy" />EBUG::listenerContainer-2:<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.persistence.entity.VariableInstanceEntity.deleteVariableInstance:47 - ==&gt;&nbsp; Preparing: delete from ACT_RU_VARIABLE where ID_ = ? and REV_ = ? </SPAN><BR /><SPAN>26-Mar-2014[08:25:35.759]:<img id="smileyvery-happy" class="emoticon emoticon-smileyvery-happy" src="https://connect.hyland.com/i/smilies/16x16_smiley-very-happy.png" alt="Smiley Very Happy" title="Smiley Very Happy" />EBUG::listenerContainer-2:<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.persistence.entity.VariableInstanceEntity.deleteVariableInstance:47 - ==&gt; Parameters: 16025359(String), 1(Integer)</SPAN><BR /><SPAN>26-Mar-2014[08:25:36.016]:<img id="smileyvery-happy" class="emoticon emoticon-smileyvery-happy" src="https://connect.hyland.com/i/smilies/16x16_smiley-very-happy.png" alt="Smiley Very Happy" title="Smiley Very Happy" />EBUG::listenerContainer-2:<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.db.DbSqlSession:574 - executing: delete VariableInstanceEntity[id=16025403, name=TaskUpdatedBy, type=string, textValue=xprk821]</SPAN><BR /><SPAN>26-Mar-2014[08:25:36.017]:<img id="smileyvery-happy" class="emoticon emoticon-smileyvery-happy" src="https://connect.hyland.com/i/smilies/16x16_smiley-very-happy.png" alt="Smiley Very Happy" title="Smiley Very Happy" />EBUG::listenerContainer-2:<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.persistence.entity.VariableInstanceEntity.deleteVariableInstance:47 - ooo Using Connection [Transaction-aware proxy for target Connection [jdbc<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />racle:thin:@//DO4501.oracle.uprr.com:1521/DO45.uprr.com, UserName=DBPE999, Oracle JDBC driver]]</SPAN><BR /><SPAN>26-Mar-2014[08:25:36.017]:<img id="smileyvery-happy" class="emoticon emoticon-smileyvery-happy" src="https://connect.hyland.com/i/smilies/16x16_smiley-very-happy.png" alt="Smiley Very Happy" title="Smiley Very Happy" />EBUG::listenerContainer-2:<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.persistence.entity.VariableInstanceEntity.deleteVariableInstance:47 - ==&gt;&nbsp; Preparing: delete from ACT_RU_VARIABLE where ID_ = ? and REV_ = ? </SPAN><BR /><SPAN>26-Mar-2014[08:25:36.017]:<img id="smileyvery-happy" class="emoticon emoticon-smileyvery-happy" src="https://connect.hyland.com/i/smilies/16x16_smiley-very-happy.png" alt="Smiley Very Happy" title="Smiley Very Happy" />EBUG::listenerContainer-2:<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.persistence.entity.VariableInstanceEntity.deleteVariableInstance:47 - ==&gt; Parameters: 16025403(String), 1(Integer)</SPAN><BR /><SPAN>26-Mar-2014[08:25:36.275]:<img id="smileyvery-happy" class="emoticon emoticon-smileyvery-happy" src="https://connect.hyland.com/i/smilies/16x16_smiley-very-happy.png" alt="Smiley Very Happy" title="Smiley Very Happy" />EBUG::listenerContainer-2:<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.db.DbSqlSession:574 - executing: delete Task[id=16025356, name=testCompletenessHumanTask]</SPAN><BR /><SPAN>26-Mar-2014[08:25:36.275]:<img id="smileyvery-happy" class="emoticon emoticon-smileyvery-happy" src="https://connect.hyland.com/i/smilies/16x16_smiley-very-happy.png" alt="Smiley Very Happy" title="Smiley Very Happy" />EBUG::listenerContainer-2:<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.persistence.entity.TaskEntity.deleteTask:47 - ooo Using Connection [Transaction-aware proxy for target Connection [jdbc<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />racle:thin:@//DO4501.oracle.uprr.com:1521/DO45.uprr.com, UserName=DBPE999, Oracle JDBC driver]]</SPAN><BR /><SPAN>26-Mar-2014[08:25:36.275]:<img id="smileyvery-happy" class="emoticon emoticon-smileyvery-happy" src="https://connect.hyland.com/i/smilies/16x16_smiley-very-happy.png" alt="Smiley Very Happy" title="Smiley Very Happy" />EBUG::listenerContainer-2:<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.persistence.entity.TaskEntity.deleteTask:47 - ==&gt;&nbsp; Preparing: delete from ACT_RU_TASK where ID_ = ? and REV_ = ? </SPAN><BR /><SPAN>26-Mar-2014[08:25:36.276]:<img id="smileyvery-happy" class="emoticon emoticon-smileyvery-happy" src="https://connect.hyland.com/i/smilies/16x16_smiley-very-happy.png" alt="Smiley Very Happy" title="Smiley Very Happy" />EBUG::listenerContainer-2:<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.persistence.entity.TaskEntity.deleteTask:47 - ==&gt; Parameters: 16025356(String), 1(Integer)</SPAN><BR /><SPAN>26-Mar-2014[08:25:36.533]:<img id="smileyvery-happy" class="emoticon emoticon-smileyvery-happy" src="https://connect.hyland.com/i/smilies/16x16_smiley-very-happy.png" alt="Smiley Very Happy" title="Smiley Very Happy" />EBUG::listenerContainer-2:<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.db.DbSqlSession:574 - executing: delete Execution[16025353]</SPAN><BR /><SPAN>26-Mar-2014[08:25:36.534]:<img id="smileyvery-happy" class="emoticon emoticon-smileyvery-happy" src="https://connect.hyland.com/i/smilies/16x16_smiley-very-happy.png" alt="Smiley Very Happy" title="Smiley Very Happy" />EBUG::listenerContainer-2:<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.persistence.entity.ExecutionEntity.deleteExecution:47 - ooo Using Connection [Transaction-aware proxy for target Connection [jdbc<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />racle:thin:@//DO4501.oracle.uprr.com:1521/DO45.uprr.com, UserName=DBPE999, Oracle JDBC driver]]</SPAN><BR /><SPAN>26-Mar-2014[08:25:36.534]:<img id="smileyvery-happy" class="emoticon emoticon-smileyvery-happy" src="https://connect.hyland.com/i/smilies/16x16_smiley-very-happy.png" alt="Smiley Very Happy" title="Smiley Very Happy" />EBUG::listenerContainer-2:<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.persistence.entity.ExecutionEntity.deleteExecution:47 - ==&gt;&nbsp; Preparing: delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ? </SPAN><BR /><SPAN>26-Mar-2014[08:25:36.536]:<img id="smileyvery-happy" class="emoticon emoticon-smileyvery-happy" src="https://connect.hyland.com/i/smilies/16x16_smiley-very-happy.png" alt="Smiley Very Happy" title="Smiley Very Happy" />EBUG::listenerContainer-2:<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.persistence.entity.ExecutionEntity.deleteExecution:47 - ==&gt; Parameters: 16025353(String), 1(Integer)</SPAN><BR /><SPAN>26-Mar-2014[08:25:37.105]:<img id="smileyvery-happy" class="emoticon emoticon-smileyvery-happy" src="https://connect.hyland.com/i/smilies/16x16_smiley-very-happy.png" alt="Smiley Very Happy" title="Smiley Very Happy" />EBUG::listenerContainer-2:<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.interceptor.CommandContext:139 - Error while closing command context</SPAN><BR /><SPAN>org.apache.ibatis.exceptions.PersistenceException: </SPAN><BR /><SPAN>### Error updating database.&nbsp; Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (BPE_ENPR.ACT_FK_VAR_EXE) violated - child record found</SPAN><BR /><BR /><SPAN>### The error may involve org.activiti.engine.impl.persistence.entity.ExecutionEntity.deleteExecution-Inline</SPAN><BR /><SPAN>### The error occurred while setting parameters</SPAN><BR /><SPAN>### SQL: delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ?</SPAN><BR /><SPAN>### Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (BPE_ENPR.ACT_FK_VAR_EXE) violated - child record found</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:147)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.delete(DefaultSqlSession.java:158)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession$CheckedDeleteOperation.execute(DbSqlSession.java:227)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.flushDeletes(DbSqlSession.java:575)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:443)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:169)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:116)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:70)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:37)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.FormServiceImpl.submitTaskFormData(FormServiceImpl.java:70)</SPAN><BR /><BR /><SPAN>When i changed the second human task to Async then first user task is getting completed and second user task is getting created. Not sure why this is happening.&nbsp; I hope even in single transaction it should have the ability to complete the first user task and invoking next user task but that is not happening if done with exclusive.</SPAN><BR /></BODY></HTML> Wed, 26 Mar 2014 15:58:39 GMT ganeshr 2014-03-26T15:58:39Z SQLIntegrityConstraintViolationException when completing User task https://connect.hyland.com/t5/alfresco-archive/sqlintegrityconstraintviolationexception-when-completing-user/m-p/164855#M118574 Facing SQLIntegrityConstraintViolationException when completing the first user task in business process. Developed business process with two human task(both exclusive) and when completing the first task getting the below exception. Business process is simple start event -&gt; user task1 -&gt; user t Wed, 26 Mar 2014 15:58:39 GMT https://connect.hyland.com/t5/alfresco-archive/sqlintegrityconstraintviolationexception-when-completing-user/m-p/164855#M118574 ganeshr 2014-03-26T15:58:39Z Re: SQLIntegrityConstraintViolationException when completing User task https://connect.hyland.com/t5/alfresco-archive/sqlintegrityconstraintviolationexception-when-completing-user/m-p/164856#M118575 <HTML><HEAD></HEAD><BODY><SPAN>Can you create a unit test showing the issue?</SPAN></BODY></HTML> Mon, 31 Mar 2014 15:03:49 GMT https://connect.hyland.com/t5/alfresco-archive/sqlintegrityconstraintviolationexception-when-completing-user/m-p/164856#M118575 trademak 2014-03-31T15:03:49Z