JBoss Community

Hi,

I'm getting the same error when running the following code

String deploymentDbid = repositoryService.createDeployment().addResourceFromClasspath("sample-process.jpdl.xml").deploy();

Map<String, Object> variables = new HashMap<String, Object>();

variables.put("content", "good");

ProcessInstance processInstance = executionService.startProcessInstanceByKey("DecisionExpression", variables);

log.info("Process reached state " + processInstance.getState());

/*

* this line produces the error

*/

executionService.signalExecutionById(processInstance.getId());

I'm using jbpm 4.3 and processInstance is a spring 2.5.6 auto-wired bean. Since I have also a JPA context for my application , aside from the hibernate context used by jbpm engine, I feared that this could somehow interfere with jbpm execution.

Can someone please provide some insight into this ?

...

Hibernate:

    /* delete one-to-many org.jbpm.pvm.internal.model.ExecutionImpl.variables */ update

            JBPM4_VARIABLE

        set

            EXECUTION_=null,

            KEY_=null

        where

            EXECUTION_=?

Hibernate:

    /* delete org.jbpm.pvm.internal.type.variable.StringVariable */ delete

        from

            JBPM4_VARIABLE

        where

            DBID_=?

            and DBVERSION_=?

Hibernate:

    /* delete org.jbpm.pvm.internal.model.ExecutionImpl */ delete

        from

            JBPM4_EXECUTION

        where

            DBID_=?

            and DBVERSION_=?

15382 [http-8080-exec-2] WARN org.hibernate.util.JDBCExceptionReporter  - SQL Error: 1451, SQLState: 23000

15382 [http-8080-exec-2] ERROR org.hibernate.util.JDBCExceptionReporter  - Cannot delete or update a parent row: a foreign key constraint fails (`jbpm`.`jbpm4_execution`, CONSTRAINT `FK_EXEC_INSTANCE` FOREIGN KEY (`INSTANCE_`) REFERENCES `jbpm4_execution` (`DBID_`))

15388 [http-8080-exec-2] ERROR org.hibernate.event.def.AbstractFlushingEventListener  - Could not synchronize database state with session

org.hibernate.exception.ConstraintViolationException: could not delete: [org.jbpm.pvm.internal.model.ExecutionImpl#7]

at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)

at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)

at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)

at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)

at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)

at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)

at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172)

at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)

at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)

at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)

at org.springframework.orm.hibernate3.SpringSessionSynchronization.beforeCommit(SpringSessionSynchronization.java:135)

at org.springframework.transaction.support.TransactionSynchronizationUtils.triggerBeforeCommit(TransactionSynchronizationUtils.java:72)

at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCommit(AbstractPlatformTransactionManager.java:905)

at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:715)

at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701)

at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)

at org.jbpm.pvm.internal.tx.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:55)

at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)

at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)

at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55)

at org.jbpm.pvm.internal.svc.ExecutionServiceImpl.signalExecutionById(ExecutionServiceImpl.java:84)

at com.example.workflow.WorkflowApplication.execute(WorkflowApplication.java:69)

at com.example.workflow.WorkflowApplication.access$0(WorkflowApplication.java:53)

at com.example.workflow.WorkflowApplication$1.buttonClick(WorkflowApplication.java:45)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:487)

at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:161)

at com.vaadin.ui.AbstractComponent.fireEvent(AbstractComponent.java:1154)

at com.vaadin.ui.Button.fireClick(Button.java:371)

at com.vaadin.ui.Button.changeVariables(Button.java:193)

at com.vaadin.terminal.gwt.server.AbstractCommunicationManager.handleVariables(AbstractCommunicationManager.java:1094)

at com.vaadin.terminal.gwt.server.AbstractCommunicationManager.doHandleUidlRequest(AbstractCommunicationManager.java:590)

at com.vaadin.terminal.gwt.server.CommunicationManager.handleUidlRequest(CommunicationManager.java:266)

at com.vaadin.terminal.gwt.server.AbstractApplicationServlet.service(AbstractApplicationServlet.java:476)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:306)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:108)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:558)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:379)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:243)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:259)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:281)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

at java.lang.Thread.run(Thread.java:619)