3 Replies Latest reply on Aug 20, 2010 2:06 AM by swiderski.maciej

jBPM 4.4 - Console won't run !

nicolasduminil123 Aug 18, 2010 1:50 PM

Greetings, after having installed jBPM 4.4 in JBoss as 5.1.0.GA i tried to open the console and, once authenticated as alex/password, I got the following exception:

2010-08-18 19:46:18,515 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3) com.mysql.jdbc.jdbc2.optional.MysqlXAException: XAER_OUTSIDE: Some work is done outside global transaction
2010-08-18 19:46:18,516 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.mapXAExceptionFromSQLException(MysqlXAConnection.java:564)
2010-08-18 19:46:18,516 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.dispatchCommand(MysqlXAConnection.java:547)
2010-08-18 19:46:18,516 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.start(MysqlXAConnection.java:488)
2010-08-18 19:46:18,516 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:213)
2010-08-18 19:46:18,516 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:799)
2010-08-18 19:46:18,516 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:510)
2010-08-18 19:46:18,516 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener$TransactionSynchronization.enlist(TxConnectionManager.java:908)
2010-08-18 19:46:18,516 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:662)
2010-08-18 19:46:18,516 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:403)
2010-08-18 19:46:18,516 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jboss.resource.connectionmanager.BaseConnectionManager2.reconnectManagedConnection(BaseConnectionManager2.java:625)
2010-08-18 19:46:18,516 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:499)
2010-08-18 19:46:18,516 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
2010-08-18 19:46:18,516 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
2010-08-18 19:46:18,516 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)
2010-08-18 19:46:18,516 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
2010-08-18 19:46:18,516 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
2010-08-18 19:46:18,517 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
2010-08-18 19:46:18,517 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1573)
2010-08-18 19:46:18,517 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.hibernate.loader.Loader.doQuery(Loader.java:696)
2010-08-18 19:46:18,517 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
2010-08-18 19:46:18,517 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.hibernate.loader.Loader.doList(Loader.java:2228)
2010-08-18 19:46:18,517 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
2010-08-18 19:46:18,517 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.hibernate.loader.Loader.list(Loader.java:2120)
2010-08-18 19:46:18,517 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
2010-08-18 19:46:18,517 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361)
2010-08-18 19:46:18,517 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
2010-08-18 19:46:18,517 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148)
2010-08-18 19:46:18,517 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
2010-08-18 19:46:18,517 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jbpm.pvm.internal.query.AbstractQuery.execute(AbstractQuery.java:93)
2010-08-18 19:46:18,517 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jbpm.pvm.internal.query.TaskQueryImpl.execute(TaskQueryImpl.java:231)
2010-08-18 19:46:18,517 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jbpm.pvm.internal.query.AbstractQuery.execute(AbstractQuery.java:83)
2010-08-18 19:46:18,517 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)
2010-08-18 19:46:18,517 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jbpm.pvm.internal.tx.JtaTransactionInterceptor.executeInNewTx(JtaTransactionInterceptor.java:83)
2010-08-18 19:46:18,517 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jbpm.pvm.internal.tx.JtaTransactionInterceptor.execute(JtaTransactionInterceptor.java:62)
2010-08-18 19:46:18,518 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:56)
2010-08-18 19:46:18,518 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jbpm.pvm.internal.tx.JtaRetryInterceptor.executeWithRetry(JtaRetryInterceptor.java:52)
2010-08-18 19:46:18,518 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jbpm.pvm.internal.tx.JtaRetryInterceptor.execute(JtaRetryInterceptor.java:45)
2010-08-18 19:46:18,518 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)
2010-08-18 19:46:18,518 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)
2010-08-18 19:46:18,518 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jbpm.pvm.internal.svc.SkipInterceptor.execute(SkipInterceptor.java:43)
2010-08-18 19:46:18,518 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jbpm.pvm.internal.query.AbstractQuery.untypedList(AbstractQuery.java:64)
2010-08-18 19:46:18,518 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jbpm.pvm.internal.query.TaskQueryImpl.list(TaskQueryImpl.java:255)
2010-08-18 19:46:18,518 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jbpm.pvm.internal.svc.TaskServiceImpl.findPersonalTasks(TaskServiceImpl.java:130)
2010-08-18 19:46:18,518 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jbpm.integration.console.TaskManagementImpl.getAssignedTasks(TaskManagementImpl.java:48)
2010-08-18 19:46:18,518 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jboss.bpm.console.server.TaskListFacade.getTasksForIdRef(TaskListFacade.java:99)
2010-08-18 19:46:18,518 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2010-08-18 19:46:18,518 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
2010-08-18 19:46:18,518 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2010-08-18 19:46:18,518 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at java.lang.reflect.Method.invoke(Method.java:597)
2010-08-18 19:46:18,518 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:117)
2010-08-18 19:46:18,518 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:260)
2010-08-18 19:46:18,518 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:232)
2010-08-18 19:46:18,518 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:166)
2010-08-18 19:46:18,519 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jboss.resteasy.core.DispatcherUtilities.getJaxrsResponse(DispatcherUtilities.java:142)
2010-08-18 19:46:18,519 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356)
2010-08-18 19:46:18,519 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:173)
2010-08-18 19:46:18,519 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:93)
2010-08-18 19:46:18,519 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:68)
2010-08-18 19:46:18,519 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
2010-08-18 19:46:18,519 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
2010-08-18 19:46:18,519 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
2010-08-18 19:46:18,519 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)
2010-08-18 19:46:18,519 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
2010-08-18 19:46:18,519 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
2010-08-18 19:46:18,519 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
2010-08-18 19:46:18,519 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
2010-08-18 19:46:18,519 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
2010-08-18 19:46:18,519 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
2010-08-18 19:46:18,519 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
2010-08-18 19:46:18,519 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
2010-08-18 19:46:18,519 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
2010-08-18 19:46:18,520 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
2010-08-18 19:46:18,520 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
2010-08-18 19:46:18,520 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
2010-08-18 19:46:18,520 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
2010-08-18 19:46:18,520 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
2010-08-18 19:46:18,520 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
2010-08-18 19:46:18,520 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
2010-08-18 19:46:18,520 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
2010-08-18 19:46:18,520 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
2010-08-18 19:46:18,520 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
2010-08-18 19:46:18,520 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
2010-08-18 19:46:18,520 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-3)      at java.lang.Thread.run(Thread.java:619)
2010-08-18 19:46:18,632 WARN [org.hibernate.util.JDBCExceptionReporter] (http-localhost%2F127.0.0.1-8080-3) SQL Error: 0, SQLState: null
2010-08-18 19:46:18,632 ERROR [org.hibernate.util.JDBCExceptionReporter] (http-localhost%2F127.0.0.1-8080-3) Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: -53e86af3:f511:4c6c10b1:2182 status: ActionStatus.ABORT_ONLY >); - nested throwable: (org.jboss.resource.JBossResourceException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: -53e86af3:f511:4c6c10b1:2182 status: ActionStatus.ABORT_ONLY >))
2010-08-18 19:46:18,634 INFO [org.jbpm.pvm.internal.svc.DefaultCommandService] (http-localhost%2F127.0.0.1-8080-3) exception while executing command org.jbpm.pvm.internal.query.TaskQueryImpl@4e4c86aa
org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)

I'm using MySQL 5. Please help. Many thanks in advance.

Nicolas

1. Re: jBPM 4.4 - Console won't run !

rebody Aug 18, 2010 9:15 PM (in response to nicolasduminil123)

Hi Nicolas,

Because there is a 'Cannot open connection' Exception, So I suggest you to re-check the configuration of jdbc.
Actions
2. Re: jBPM 4.4 - Console won't run !

nicolasduminil123 Aug 19, 2010 5:26 AM (in response to rebody)

There is a "Can't Open Connection" because there is an XA exception. And the XA exception is raised because the xa-datasource isn't supported, at least with MySQL Connector/J 5.0.7, MySQL Cluster Server Pro 5.1.39, on a Linux kernel 2.6.18-164.el5. Replacing the xa-datasource with a local one solves the problem. So, at least for this configuration, the jBPM 4.4 installer (ant install.jbpm.into.jboss) incorrectly creates the jbpm-mysql-ds.xml file to use xa datasources. This file has to be modified manually, as a post-install operation, such that to replace the xa-datasource element by a local-tx-datasource one, in order to get the product working.
Actions
3. Re: jBPM 4.4 - Console won't run !

swiderski.maciej Aug 20, 2010 2:06 AM (in response to nicolasduminil123)

Nicolas, could you please create a jira issue for this and set fix version to 4.5? To track it and have it fixed asap.

Cheers
Actions

Go to original post