topic After finishing multi instance user task, tasks sometimes remain in the database, causing integrity constraint violation in Alfresco Archive

After finishing multi instance user task, tasks sometimes remain in the database, causing integrity constraint violation

mcajvar — Tue, 19 Apr 2016 14:35:01 GMT

Hello,I have a problem when completing tasks. We have a process (see attachment) with some tasks to handle a request. There is also a multi instance user task where people can decide to ignore or accept the request. If it is rejected, an error end event is triggered, which does some cleanup, sends a

Re: After finishing multi instance user task, tasks sometimes remain in the database, causing integrity constraint violation

trademak — Wed, 20 Apr 2016 07:18:22 GMT

Hi,

Did you try to use a multi instance sub process with an error boundary event instead of using the multi instance user task? I think that better aligns with your requirements. Activiti 5.20.0 is released so you could try that Engine version as well. A terminate end event would be needed if you want to stop all multi instance executions.

Best regards,

Re: After finishing multi instance user task, tasks sometimes remain in the database, causing integrity constraint violation

mcajvar — Wed, 20 Apr 2016 09:35:48 GMT

Hi,

no, I didn't use a multi instance subprocess. The real process is actually a bit more complex, with lots of other user and service tasks. This is just a stripped down version which I was hoping to use for a unit test. But it is still valid as it still fails.

The multi instance user task is actually just a simple form where some data is displayed to one or more people and they either confirm or reject that info. I set a variable depending on that input and that's it. I use some other multi instance user tasks in the process, but only this one causes me problems.

Thank you for info on 5.20.0 being released, I will have a look. Although I don't really believe the appropriate way to solve the issue is to force kill (stale) tasks at the end.

Re: After finishing multi instance user task, tasks sometimes remain in the database, causing integrity constraint violation

mcajvar — Thu, 21 Apr 2016 10:15:02 GMT

Having tried Activiti 5.20.0 and swapping End Events with Terminate End Events with activiti:terminateAll="true" thrown in for good measure, the error occurs anyway.

Caused by: org.apache.ibatis.exceptions.PersistenceException: 
### Error updating database.  Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (UP.ACT_FK_EXE_PARENT) violated - child record found

### The error may involve org.activiti.engine.impl.persistence.entity.ExecutionEntity.deleteExecution-Inline
### The error occurred while setting parameters
### SQL: delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ?
### Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (UP.ACT_FK_EXE_PARENT) violated - child record found

If I throw out the multi instance loop characteristic and only have a plain user task, everything is OK, with both Terminate End Events or normal End Events…

Re: After finishing multi instance user task, tasks sometimes remain in the database, causing integrity constraint violation

jbarrez — Tue, 26 Apr 2016 13:10:31 GMT

First off all: I'm agreeing with Tijs here that the paradigm you're trying to express here (mi task with error throw) is better modeled as an embedded subprocess.
Secondly, can you post a unit test on how to reproduce this? It's already quite a process (with custom service task) and setting this up takes some time on our end.

Re: After finishing multi instance user task, tasks sometimes remain in the database, causing integrity constraint violation

venkatesh — Mon, 23 May 2016 16:12:11 GMT

Hi,

can u give me some idea to end the multiInstance parallel task in a subProcess.
consider the scenorio tat i have Two tasks in multiInstance parallel .
i am completing one task and in service Task i am getting all the active tasks so, i will get the remaining task but when i tried to complete it i am getting ### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (UP.ACT_FK_EXE_PARENT) violated - child record found

### The error may involve org.activiti.engine.impl.persistence.entity.ExecutionEntity.deleteExecution-Inline
### The error occurred while setting parameters
### SQL: delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ?
### Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (UP.ACT_FK_EXE_PARENT) violated - child record found.

case 2 : after the userr task i am setting variable action="SENDBACK " and moving towards the service task and am jus ending with the terminateEndEvent . but the entire SubProcess event and tasks nt at terminating instead am getting completed wit only one task and nt all tasks . so it is still in subProcess not coming out of it untill unless i complete twice.

Re: After finishing multi instance user task, tasks sometimes remain in the database, causing integrity constraint violation

jbarrez — Tue, 31 May 2016 09:57:49 GMT

It's a pretty big process xml file … can you describe the steps how i can reproduce the error you're describing in a unit test?