6 Replies Latest reply on Nov 14, 2014 2:48 AM by swiderski.maciej

jBPM6 PER_PROCESS_INSTANCE strategy in WebSphere8.5.5 Unable to commit transaction exception

stevenhu Nov 11, 2014 11:12 AM

I am evaluating the PER_PROCESS_INSTANCE strategy. I can successfully start a process, and get the human task data and show them on page, but I run into the following error below when I am trying to call TaskService.complete() to complete the final human task. Based on the guide, I also provide the process instance id to build the runtime engine. But I still got the same error. Can anybody kindly give some suggestions? Thanks in advance.

the environment: WebSphere Application Server 8.5.5.2,

Oracle 11g

jbpm 6.1.0.Final,

a web application as jbpm client via Remote Rest API

database based user role

I created the runtime engine like the below:

RemoteRestRuntimeEngineFactoryBuilder builder = RemoteRestRuntimeEngineFactory.newBuilder();

builder.addDeploymentId(bpmProcessContext)

.addUserName(env.getWorkbenchUser())

.addPassword(env.getWorkbenchPwd())

.addUrl(new URL(env.getWorkbenchUrl()))

.addTimeout(60);

builder.addProcessInstanceId(processInstanceId);

RemoteRestRuntimeEngineFactory factory = builder.build();

runtimeEngine = factory.newRuntimeEngine();

The client-end exception trace stack is shown below, and the detailed jbpm workbench log including step-by-step sql statements is attached.

[11/10/14 18:11:44:186 EST] 000000ff SystemOut O 4446752 2014-11-10 18:11:44,186 TRACE WebContainer : 5 org.kie.services.client.api.command.AbstractRemoteCommandObject - Sending CompositeCommand via POST to http://ptapp03:9080/scf/wfe/rest/runtime/com.pti.fsc.cda:cda-bpm:1.0.0/execute

<?xml version="1.0" encoding="UTF-8" standalone="yes"?><command-request><deployment-id>com.pti.fsc.cda:cda-bpm:1.0.0</deployment-id><process-instance-id>874</process-instance-id><ver>6.1.0.1</ver><task-composite-command><mainCommand xsi:type="completeTaskCommand" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><task-id>1513</task-id><user-id>john</user-id><data><item key="taskResult"><value xsi:type="xs:string" xmlns:xs="http://www.w3.org/2001/XMLSchema">createApproved</value></item></data></mainCommand><commands xsi:type="executeTaskRulesCommand" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><task-id>1513</task-id><user-id>john</user-id><data><item key="taskResult"><value xsi:type="xs:string" xmlns:xs="http://www.w3.org/2001/XMLSchema">createApproved</value></item></data><scope>completeTask</scope></commands><commands xsi:type="processSubTaskCommand" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><task-id>1513</task-id><user-id>john</user-id><data><item key="taskResult"><value xsi:type="xs:string" xmlns:xs="http://www.w3.org/2001/XMLSchema">createApproved</value></item></data></commands><commands xsi:type="cancelDeadlineCommand" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><task-id>1513</task-id><removeStart>true</removeStart><removeEnd>true</removeEnd></commands></task-composite-command></command-request>

[11/10/14 18:11:44:186 EST] 000000ff SystemOut O 4446752 2014-11-10 18:11:44,186 DEBUG WebContainer : 5 org.kie.services.client.api.command.AbstractRemoteCommandObject - Sending POST request with CompositeCommand to http://ptapp03:9080/scf/wfe/rest/runtime/com.pti.fsc.cda:cda-bpm:1.0.0/execute

[11/10/14 18:11:44:391 EST] 000000ff SystemOut O 4446956 2014-11-10 18:11:44,390 ERROR WebContainer : 5 - *********** completeTask error

org.kie.services.client.api.command.exception.RemoteApiException: RollbackException thrown with message 'null':

java.lang.RuntimeException: Unable to commit transaction

at org.drools.persistence.jta.JtaTransactionManager.commit(JtaTransactionManager.java:212)

at org.jbpm.services.task.persistence.TaskTransactionInterceptor.execute(TaskTransactionInterceptor.java:56)

at org.jbpm.services.task.commands.TaskCommandExecutorImpl.execute(TaskCommandExecutorImpl.java:40)

at org.jbpm.services.task.impl.command.CommandBasedTaskService.execute(Unknown Source)

at org.kie.remote.services.cdi.ProcessRequestBean.doTaskOperation(ProcessRequestBean.java:245)

at org.kie.remote.services.cdi.ProcessRequestBean.processCommand(ProcessRequestBean.java:120)

at sun.reflect.GeneratedMethodAccessor371.invoke(Unknown Source)

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

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

at org.apache.webbeans.intercept.InterceptorHandler.invoke(InterceptorHandler.java:297)

at org.apache.webbeans.intercept.NormalScopedBeanInterceptorHandler.invoke(NormalScopedBeanInterceptorHandler.java:98)

at org.kie.remote.services.cdi.ProcessRequestBean_$$_javassist_535.processCommand(ProcessRequestBean_$$_javassist_535.java)

at org.kie.remote.services.rest.ResourceBase.restProcessJaxbCommandsRequest(ResourceBase.java:73)

at org.kie.remote.services.rest.RuntimeResource.execute(RuntimeResource.java:104)

at sun.reflect.GeneratedMethodAccessor380.invoke(Unknown Source)

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

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

at org.apache.webbeans.intercept.InterceptorHandler.invoke(InterceptorHandler.java:297)

at org.apache.webbeans.intercept.NormalScopedBeanInterceptorHandler.invoke(NormalScopedBeanInterceptorHandler.java:98)

at org.kie.remote.services.rest.RuntimeResource_$$_javassist_537.execute(RuntimeResource_$$_javassist_537.java)

at sun.reflect.GeneratedMethodAccessor380.invoke(Unknown Source)

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

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

at org.apache.wink.server.internal.handlers.InvokeMethodHandler.handleRequest(InvokeMethodHandler.java:63)

at org.apache.wink.server.handlers.AbstractHandler.handleRequest(AbstractHandler.java:33)

at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)

at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)