topic Re: 'Integrity constraint violation' between CallActivities in Alfresco Archive

'Integrity constraint violation' between CallActivities

gokceng1 — Mon, 17 Dec 2012 07:58:24 GMT

Hi,I have some complex process definition consisting of 12 call activities. You can find main process here.The error stack is here:5924 [main] ERROR org.activiti.engine.impl.interceptor.CommandContext - Error while closing command contextorg.apache.ibatis.exceptions.PersistenceException: ### Error

Re: 'Integrity constraint violation' between CallActivities

jbarrez — Tue, 18 Dec 2012 16:29:49 GMT

Very tricky to say something for a process of this size, so

I can prepare a test project if you demand.

That would be very helpful… Even better is a 'minimal' version of your process, where the error still happens.

Re: 'Integrity constraint violation' between CallActivities

gokceng1 — Thu, 20 Dec 2012 12:09:26 GMT

Hi,
I've created 2 projects, one is utility used in the main test project: Util, Test

I've commented briefly test execution in code, if there is still problem please inform me, I will reply asap.

Thanks in advance.

Re: 'Integrity constraint violation' between CallActivities

gokceng1 — Fri, 28 Dec 2012 08:39:44 GMT

Were you able to look at test projects?

Re: 'Integrity constraint violation' between CallActivities

mokematt — Thu, 12 Dec 2013 15:02:23 GMT

Hi,

is there any conclusion for this topic?
i got an similar error in my process on an oracle database.

<code>
2013-12-12 15:38:59,564 [XML-RPC-0] ERROR org.activiti.engine.impl.interceptor.CommandContext - Error while closing command context
org.apache.ibatis.exceptions.PersistenceException:
### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (ACTIVITI.ACT_FK_EVENT_EXEC) 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 (ACTIVITI.ACT_FK_EVENT_EXEC) violated - child record found

        at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
        at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:150)
        at org.apache.ibatis.session.defaults.DefaultSqlSession.delete(DefaultSqlSession.java:161)
        at org.activiti.engine.impl.db.DbSqlSession$CheckedDeleteOperation.execute(DbSqlSession.java:225)
        at org.activiti.engine.impl.db.DbSqlSession.flushDeletes(DbSqlSession.java:577)
        at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:445)
        at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:170)
        at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:117)
        at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:66)
        at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)
        at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)
        at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35)
        at org.activiti.engine.impl.FormServiceImpl.submitTaskFormData(FormServiceImpl.java:70)
        at pucco.activiti.ActivitiService.completeTask(ActivitiService.java:160)
        at pucco.gwt.cls.CompleteTask.execute(CompleteTask.java:30)
        at pucco.gwt.GwtFunctionCall.call(GwtFunctionCall.java:65)
        at pucco.gwt.GwtFunctionService.completeTask(GwtFunctionService.java:44)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at org.apache.xmlrpc.server.ReflectiveXmlRpcHandler.invoke(ReflectiveXmlRpcHandler.java:115)
        at org.apache.xmlrpc.server.ReflectiveXmlRpcHandler.execute(ReflectiveXmlRpcHandler.java:106)
        at org.apache.xmlrpc.server.XmlRpcServerWorker.execute(XmlRpcServerWorker.java:46)
        at org.apache.xmlrpc.server.XmlRpcServer.execute(XmlRpcServer.java:86)
        at org.apache.xmlrpc.server.XmlRpcStreamServer.execute(XmlRpcStreamServer.java:200)
        at org.apache.xmlrpc.webserver.Connection.run(Connection.java:208)
        at org.apache.xmlrpc.util.ThreadPool$Poolable$1.run(ThreadPool.java:68)
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (ACTIVITI.ACT_FK_EVENT_EXEC) violated - child record found

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1046)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)
        at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3714)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1378)
        at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:41)
        at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:66)
        at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:45)
        at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:100)
        at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)
        at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:148)
        … 26 more
</code>

greets

Matthias

Re: 'Integrity constraint violation' between CallActivities

jbarrez — Tue, 17 Dec 2013 10:36:26 GMT

When do you see this happening? Which call did you do that led to this stacktrace?

Re: 'Integrity constraint violation' between CallActivities

mokematt — Wed, 18 Dec 2013 08:15:10 GMT

This exception comes, when the end event of the process is reached and the process instance should be closed. Also a RuntimeService.deleteProcessInstance() throws the same exception.

I analysed this problem and came to following result:
In the ACT_RU_EXECUTION table were some executions that belongs to my process instance. The process instance execution itself, a subprocess and two executions for compensation events. Then i deleted the two execution lines for the compensation events and RuntimeService.deleteProcessInstance() finished successfully.
After that i deleted the compensation events and its service tasks from my process definition and the exceptions are not thrown any more.

I attached both process definitions to this post.

greets
Matthias

Re: 'Integrity constraint violation' between CallActivities

frederikherema1 — Wed, 18 Dec 2013 11:26:37 GMT

Thanks for the thorough reporting and investigation, it's clearly the compensation-events that are the culprit. Even though they are marked as "EXPERIMENTAL", this kind of behaviour should be avoided. I'll look into this later today…

Re: 'Integrity constraint violation' between CallActivities

gokceng1 — Tue, 01 Apr 2014 21:38:34 GMT

Hi frederik,
After 2 years, I've faced with the same problem using both 5.14 and 5.15 versions.
For 5.14, after some debugging I've seen that ExecutionEntity.ensureEventSubscriptionsInitialized method only loads eventSubscriptions when eventSubscriptions is null. We have similar 2 processes:
In 1 process when the code execution hits line number 1116, eventSubscriptions is null, so it retrieves the event subscriptions and it ends without a problem. In other process when the code execution hits line number 1116 eventSubscriptions is an empty list and this causes skipping retrieving subscriptions and problem occurs.

I'll take a look at why this occurs in my spare time but I wanted to give you a hint.
We've overcome this problem by this:

if (eventSubscriptions == null || eventSubscriptions.isEmpty()) {

      eventSubscriptions = Context.getCommandContext()
        .getEventSubscriptionEntityManager()
        .findEventSubscriptionsByExecution(id);
    }

Thank you.

Re: 'Integrity constraint violation' between CallActivities

jbarrez — Tue, 22 Apr 2014 08:17:02 GMT

That sounds indeed like a bug. Feel free to submit a pull request, as you pretty much solved it 🙂