[jBPM Users] - Unable to complete task
by TejJBPM
JBPM 4.2
I am unable to complete a task. It throws a hiberanate exception. Any pointers??
I found a JIRA with a similar issue but I am not giving Async as an attribute in the start node but still get the same error
https://jira.jboss.org/jira/browse/JBPM-2535?page=com.atlassian.jira.plug...
JPDL
<?xml version="1.0" encoding="UTF-8"?>
|
| <process key="moves" name="moves" xmlns="http://jbpm.org/4/jpdl">
| <start g="372,12,49,73" name="start1">
| <transition to="Request_New_Move"/>
| </start>
| <task form="request_move.xsl" g="312,72,169,52" name="Request_New_Move">
| <transition g="-43,-5" name="submit" to="Line_Manager_review"/>
| </task>
| <task assignee="${reqLoginName}" form="linemanagerreview" g="312,288,169,52" name="Line_Manager_review">
| <notification>
| <to users="${task.assignee}"/>
| <cc addresses="${lmEmail}"/>
| <subject>${task.name}</subject>
| <text>
| <![CDATA[Hi ${task.assignee},
| Task "${task.name}" has been assigned to you.
| ${task.description}
| Sent by JBoss jBPM
| ]]>
| </text>
| </notification>
| <transition g="-57,-4" name="approve" to="Send_approval_email"/>
| <transition g="18,-5" name="reject" to="Send_rejection_email"/>
| </task>
| <end g="384,480,48,48" name="end1"/>
| <mail g="240,408,133,40" name="Send_approval_email">
| <to addresses="somebody(a)office.com"/>
| <subject>Your move request is approved!</subject>
| <text>Employee name ${employeeName} and request details ${requestDetails}</text>
| <transition to="end1"/>
| </mail>
| <mail g="432,408,133,37" name="Send_rejection_email">
| <to addresses="somebody(a)office.com"/>
| <subject>Your move request is rejected!</subject>
| <text>Employee name ${employeeName} and request details ${requestDetails}</text>
| <transition to="end1"/>
| </mail>
| </process>
Error
org.hibernate.NonUniqueResultException: query did not return a unique result: 2
| at org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:844)
| at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:835)
| at org.jbpm.pvm.internal.hibernate.DbSessionImpl.findTaskByExecution(DbSessionImpl.java:386)
| at org.jbpm.jpdl.internal.activity.MailListener.notify(MailListener.java:50)
| at org.jbpm.pvm.internal.model.op.ExecuteEventListener.perform(ExecuteEventListener.java:81)
| at org.jbpm.pvm.internal.model.ExecutionImpl.performAtomicOperationSync(ExecutionImpl.java:655)
| at org.jbpm.pvm.internal.model.ExecutionImpl.performAtomicOperation(ExecutionImpl.java:615)
| at org.jbpm.pvm.internal.model.ExecutionImpl.signal(ExecutionImpl.java:416)
| at org.jbpm.pvm.internal.model.ExecutionImpl.signal(ExecutionImpl.java:402)
| 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 org.hibernate.proxy.pojo.javassist.JavassistLazyInitializer.invoke(JavassistLazyInitializer.java:197)
| at org.jbpm.pvm.internal.model.ExecutionImpl_$$_javassist_5.signal(ExecutionImpl_$$_javassist_5.java)
| at org.jbpm.pvm.internal.task.TaskImpl.complete(TaskImpl.java:194)
| at org.jbpm.pvm.internal.cmd.CompleteTaskCmd.execute(CompleteTaskCmd.java:60)
| at org.jbpm.pvm.internal.cmd.CompleteTaskCmd.execute(CompleteTaskCmd.java:32)
| at org.jbpm.pvm.internal.cmd.CompositeCmd.execute(CompositeCmd.java:43)
| at org.jbpm.pvm.internal.cmd.CompositeCmd.execute(CompositeCmd.java:35)
| at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)
| at org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:54)
| 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.SkipInterceptor.execute(SkipInterceptor.java:43)
| at org.jbpm.pvm.internal.svc.TaskServiceImpl.completeTask(TaskServiceImpl.java:105)
|
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4267694#4267694
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4267694
14 years, 7 months
[JBoss Portal Users] - Why this exception occurs?
by thinwath
Hello,
I'm using Portal 2.7.0 and configured a local-tx-datasource which I'm using with hibernate so that it uses the JTA Tx.
Don't why but often this exception is thrown and my whole portal doesn't work anymore
| exception
|
| javax.servlet.ServletException: javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: a05dd21:43df:4b0d585b:37546 status: ActionStatus.ABORT_ONLY >
| java.lang.Exception.<init>(Exception.java:77)
| javax.servlet.ServletException.<init>(ServletException.java:86)
| org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
| javax.servlet.http.HttpServlet.service(HttpServlet.java:798)
| com.cj.trim.trimFilter.doFilter(Unknown Source)
| org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:89)
|
|
| root cause
|
| javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: a05dd21:43df:4b0d585b:37546 status: ActionStatus.ABORT_ONLY >
| java.lang.Throwable.<init>(Throwable.java:196)
| java.lang.Exception.<init>(Exception.java:41)
| javax.transaction.SystemException.<init>(SystemException.java:39)
| org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener$TransactionSynchronization.checkEnlisted(TxConnectionManager.java:750)
| org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:486)
| org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:352)
| org.jboss.resource.connectionmanager.BaseConnectionManager2.reconnectManagedConnection(BaseConnectionManager2.java:524)
| org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:392)
| org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:849)
| org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
| org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:65)
| org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)
| org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:140)
| org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:138)
| org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1517)
| org.hibernate.loader.Loader.doQuery(Loader.java:665)
| org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:232)
| org.hibernate.loader.Loader.loadEntity(Loader.java:1851)
| org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
| org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
| org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3036)
| org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:394)
| org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:331)
| org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:129)
| org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:170)
| org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:60)
| org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:874)
| org.hibernate.impl.SessionImpl.get(SessionImpl.java:812)
| org.hibernate.impl.SessionImpl.get(SessionImpl.java:808)
| org.jboss.portal.core.impl.model.portal.PersistentPortalObjectContainer.getObjectNode(PersistentPortalObjectContainer.java:282)
| org.jboss.portal.core.impl.model.portal.PersistentPortalObjectContainer.getObjectNode(PersistentPortalObjectContainer.java:252)
| org.jboss.portal.core.impl.model.portal.AbstractPortalObjectContainer.getContext(AbstractPortalObjectContainer.java:107)
| org.jboss.portal.core.impl.model.portal.AbstractPortalObjectContainer.getContext(AbstractPortalObjectContainer.java:81)
| org.jboss.portal.core.model.portal.DefaultPortalCommandFactory.doMapping(DefaultPortalCommandFactory.java:72)
| org.jboss.portal.core.controller.Controller.handle(Controller.java:252)
| org.jboss.portal.server.RequestControllerDispatcher.invoke(RequestControllerDispatcher.java:51)
| org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:104)
| org.jboss.portal.core.cms.aspect.IdentityBindingInterceptor.invoke(IdentityBindingInterceptor.java:47)
| org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
| org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:104)
| org.jboss.portal.server.aspects.server.ContentTypeInterceptor.invoke(ContentTypeInterceptor.java:68)
| org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
| org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:104)
| org.jboss.portal.core.aspects.server.PortalContextPathInterceptor.invoke(PortalContextPathInterceptor.java:45)
| org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
| org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:104)
| org.jboss.portal.core.aspects.server.LocaleInterceptor.invoke(LocaleInterceptor.java:96)
| org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
| org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:104)
| org.jboss.portal.core.aspects.server.UserInterceptor.invoke(UserInterceptor.java:193)
| org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
| org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:104)
| org.jboss.portal.server.aspects.server.SignOutInterceptor.invoke(SignOutInterceptor.java:98)
| org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
| org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:104)
| org.jboss.portal.core.impl.api.user.UserEventBridgeTriggerInterceptor.invoke(UserEventBridgeTriggerInterceptor.java:65)
| org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
| org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:104)
| org.jboss.portal.core.aspects.server.IdentityCacheInterceptor.invoke(IdentityCacheInterceptor.java:68)
| org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
| org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:104)
| org.jboss.portal.core.aspects.server.TransactionInterceptor.org$jboss$portal$core$aspects$server$TransactionInterceptor$invoke$aop(TransactionInterceptor.java:49)
| org.jboss.portal.core.aspects.server.TransactionInterceptor$invoke_N5143606530999904530.invokeNext(TransactionInterceptor$invoke_N5143606530999904530.java:0)
| org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:71)
| org.jboss.aspects.tx.TxInterceptor$RequiresNew.invoke(TxInterceptor.java:238)
| org.jboss.portal.core.aspects.server.TransactionInterceptor$invoke_N5143606530999904530.invokeNext(TransactionInterceptor$invoke_N5143606530999904530.java:0)
| org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:71)
| org.jboss.aspects.tx.TxInterceptor$RequiresNew.invoke(TxInterceptor.java:238)
| org.jboss.portal.core.aspects.server.TransactionInterceptor$invoke_N5143606530999904530.invokeNext(TransactionInterceptor$invoke_N5143606530999904530.java:0)
| org.jboss.portal.core.aspects.server.TransactionInterceptor.invoke(TransactionInterceptor.java:0)
| org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
| org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:104)
| org.jboss.portal.server.aspects.LockInterceptor$InternalLock.invoke(LockInterceptor.java:69)
| org.jboss.portal.server.aspects.LockInterceptor.invoke(LockInterceptor.java:130)
| org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:104)
| org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:141)
| org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:252)
| javax.servlet.http.HttpServlet.service(HttpServlet.java:798)
| com.cj.trim.trimFilter.doFilter(Unknown Source)
| org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:89)
|
|
Does anyone has a suggestion?
Any help will be appreciated.
Thanks
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4267685#4267685
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4267685
14 years, 7 months