AnsweredAssumed Answered

Got integrity constraint violation after process execution

Question asked by lossril on Jul 14, 2016
Latest reply on Aug 7, 2017 by gauravkumar1382@gmail.com
Hello,
I've got pretty weird bug in my Activiti system.
After the process instance is completed (everything worked pretty much smoothly, no errors) this happens:

[ERROR] 2016-07-14 11:00:17,273 org.activiti.rest.exception.ExceptionHandlerAdvice handleOtherException - Unhandled exception
org.apache.ibatis.exceptions.PersistenceException:
### Error updating database.  Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (ACTIVITI.ACT_FK_TSKASS_TASK) violated - parent key not found

### The error may involve org.activiti.engine.impl.persistence.entity.IdentityLinkEntity.bulkInsertIdentityLink_oracle-Inline
### The error occurred while setting parameters
### SQL: INSERT ALL                  into ACT_RU_IDENTITYLINK (ID_, REV_, TYPE_, USER_ID_, GROUP_ID_, TASK_ID_, PROC_INST_ID_, PROC_DEF_ID_) VALUES            (?,             1,             ?,             ?,             ?,             ?,             ?,             ?)                  into ACT_RU_IDENTITYLINK (ID_, REV_, TYPE_, USER_ID_, GROUP_ID_, TASK_ID_, PROC_INST_ID_, PROC_DEF_ID_) VALUES            (?,             1,             ?,             ?,             ?,             ?,             ?,             ?)             SELECT * FROM dual
### Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (ACTIVITI.ACT_FK_TSKASS_TASK) violated - parent key not found

All of the process parts were completed successfully, the process is not a subprocess of a bigger process.
Process itself has nothing complicated in it - here is the screenshot of the definition :
[img]https://ibin.co/2o0iFzqD19vG.png[/img]
Both reports (those two subprocesses at the end) ended correctly, but then the exception happens and the process instance rolls back.
It occurs every time if subprocesses are completed smoothly, but if something in subprocess goes wrong and administrator decision by user task completion is required, the process instance is completed successfully after user task completion.

I suppose, that's the Activiti bug.

Attachments

Outcomes