1 2 3 4 Previous Next 47 Replies Latest reply on May 24, 2013 9:47 AM by rehankhan

jBPM 5.3 jbpm-console problem

triathlon98 May 29, 2012 5:11 PM

I downloaded jBPM 5.3 and installed the demo using the ant script.

When I try the jbpm console on the evaluate process (as installed by default), then I can start the process but no tasks appear for any (I tried akrisv, mary and john as users). Using "krisv" as user name in the start process form does not make a difference.

is this normal behaviour?

How can I run trhough the full process?

Kind regards,

Joachim

P.S. Changing the user also did not work. I needed to reload the application to be able to change the user.

1. Re: jBPM 5.3 jbpm-console problem

vsid May 29, 2012 10:07 PM (in response to triathlon98)

I am running into the same issue.

Here is what I see in my logs:
21:28:33,783 ERROR [stderr] (Thread-24) java.lang.IllegalArgumentException: org.hibernate.QueryParameterException: could not locate named parameter [userId]
21:28:33,783 ERROR [stderr] (Thread-24)           at org.hibernate.ejb.QueryImpl.setParameter(QueryImpl.java:206)
21:28:33,783 ERROR [stderr] (Thread-24)           at org.jbpm.task.service.TaskServiceSession.getTasksAssignedAsPotentialOwnerByStatusByGroup(TaskServiceSession.java:1011)

I followed the below link and got around the above issue:
https://community.jboss.org/message/738279?tstart=0

However, I ran into the following issue:
21:37:22,714 ERROR [stderr] (Thread-26) javax.persistence.NoResultException: No entity found for query
21:37:22,714 ERROR [stderr] (Thread-26)           at org.hibernate.ejb.QueryImpl.getSingleResult(QueryImpl.java:104)
21:37:22,714 ERROR [stderr] (Thread-26)           at org.jbpm.task.service.TaskServiceSession.getTaskByWorkItemId(TaskServiceSession.java:644)

What are we missing?

Thanks,
Sid.
Actions
2. Re: jBPM 5.3 jbpm-console problem

swiderski.maciej May 30, 2012 1:01 AM (in response to triathlon98)

Could you please upload your server.log?

Cheers
Actions
3. Re: jBPM 5.3 jbpm-console problem

triathlon98 May 30, 2012 8:28 AM (in response to swiderski.maciej)

I also have the userId problem. From the logs:

23:07:33,566 ERROR [stderr] (Thread-19) java.lang.IllegalArgumentException: org.hibernate.QueryParameterException: could not locate named parameter [userId]
23:07:33,567 ERROR [stderr] (Thread-19)     at org.hibernate.ejb.QueryImpl.setParameter(QueryImpl.java:206)
23:07:33,567 ERROR [stderr] (Thread-19)     at org.jbpm.task.service.TaskServiceSession.getTasksAssignedAsPotentialOwnerByStatusByGroup(TaskServiceSession.java:1011)
23:07:33,567 ERROR [stderr] (Thread-19)     at org.jbpm.task.service.TaskServerHandler.messageReceived(TaskServerHandler.java:356)
23:07:33,567 ERROR [stderr] (Thread-19)     at org.jbpm.task.service.hornetq.HornetQTaskServerHandler.messageReceived(HornetQTaskServerHandler.java:44)
23:07:33,567 ERROR [stderr] (Thread-19)     at org.jbpm.task.service.hornetq.BaseHornetQTaskServer.run(BaseHornetQTaskServer.java:85)
23:07:33,567 ERROR [stderr] (Thread-19)     at java.lang.Thread.run(Thread.java:662)
23:07:33,568 ERROR [stderr] (Thread-19) Caused by: org.hibernate.QueryParameterException: could not locate named parameter [userId]
23:07:33,568 ERROR [stderr] (Thread-19)     at org.hibernate.engine.query.ParameterMetadata.getNamedParameterDescriptor(ParameterMetadata.java:99)
23:07:33,568 ERROR [stderr] (Thread-19)     at org.hibernate.engine.query.ParameterMetadata.getNamedParameterExpectedType(ParameterMetadata.java:105)
23:07:33,568 ERROR [stderr] (Thread-19)     at org.hibernate.impl.AbstractQueryImpl.determineType(AbstractQueryImpl.java:437)
23:07:33,568 ERROR [stderr] (Thread-19)     at org.hibernate.impl.AbstractQueryImpl.setParameter(AbstractQueryImpl.java:407)
23:07:33,569 ERROR [stderr] (Thread-19)     at org.hibernate.ejb.QueryImpl.setParameter(QueryImpl.java:201)
23:07:33,569 ERROR [stderr] (Thread-19)     ... 5 more
Actions
4. Re: jBPM 5.3 jbpm-console problem

jnorris May 30, 2012 8:32 AM (in response to triathlon98)

I also ran into a problem with the console in 5.3 which I think is due to the human-task-manager-war.war. Although all war files are deployed in AS7, an exception from the server log during startup is below. The second exception trace shown resulted when clicking on Group Tasks for user krisv.

07:57:32,467 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (MSC service thread 1-5) IJ000612: Destroying connection that could not be successfully matched: org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@a8c6e1[state=DESTROYED managed connection=org.jboss.jca.adapters.jdbc.local.LocalManagedConnection@1aba67 connection handles=0 lastUse=1338379052451 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@2479e7 pool internal context=org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool@bf6a50 xaResource=org.jboss.jca.core.tx.jbossts.LocalXAResourceImpl@c400df txSync=null]
07:57:32,498 WARN [org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory] (MSC service thread 1-5) Destroying connection that is not valid, due to the following exception: oracle.jdbc.driver.T4CConnection@153705: java.sql.SQLSyntaxErrorException: ORA-00923: FROM keyword not found where expected

          at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
          at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
          at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
          at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
          at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
          at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
          at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
          at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:852)
          at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)
          at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
          at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1890)
          at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1855)
          at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:304)
          at org.jboss.jca.adapters.jdbc.CheckValidConnectionSQL.isValidConnection(CheckValidConnectionSQL.java:74)
          at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:1151)
          at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkValid(BaseWrapperManagedConnection.java:454)
          at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.matchManagedConnections(LocalManagedConnectionFactory.java:507)
          at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:260)
          at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:392)
          at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:357)
          at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:351)
          at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:367)
          at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:467)
          at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:129)
          at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92) [hibernate-core-3.3.2.GA.jar:]
          at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446) [hibernate-core-3.3.2.GA.jar:]
          at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167) [hibernate-core-3.3.2.GA.jar:]
          at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142) [hibernate-core-3.3.2.GA.jar:]
          at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85) [hibernate-core-3.3.2.GA.jar:]
          at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1354) [hibernate-core-3.3.2.GA.jar:]
          at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:38) [hibernate-entitymanager-3.4.0.GA.jar:]
          at org.jbpm.task.service.persistence.TaskLocalTransactionManager.begin(TaskLocalTransactionManager.java:42) [jbpm-human-task-core-5.3.0.Final.jar:]
          at org.jbpm.task.service.persistence.TaskPersistenceManager.beginTransaction(TaskPersistenceManager.java:79) [jbpm-human-task-core-5.3.0.Final.jar:]
          at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:976) [jbpm-human-task-core-5.3.0.Final.jar:]
          at org.jbpm.task.service.TaskServiceSession.persistInTransaction(TaskServiceSession.java:957) [jbpm-human-task-core-5.3.0.Final.jar:]
          at org.jbpm.task.service.TaskServiceSession.addGroup(TaskServiceSession.java:119) [jbpm-human-task-core-5.3.0.Final.jar:]
          at org.jbpm.task.service.TaskService.addUsersAndGroups(TaskService.java:233) [jbpm-human-task-core-5.3.0.Final.jar:]
          at org.jbpm.task.servlet.HumanTaskServiceServlet.init(HumanTaskServiceServlet.java:188) [classes:]
          at javax.servlet.GenericServlet.init(GenericServlet.java:242) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
          at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1202) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1102) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3631) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at org.apache.catalina.core.StandardContext.start(StandardContext.java:3844) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at org.jboss.as.web.deployment.WebDeploymentService.start(WebDeploymentService.java:70) [jboss-as-web-7.0.2.Final.jar:7.0.2.Final]
          at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1824)
          at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1759)
          at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [:1.6.0_24]
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [:1.6.0_24]
          at java.lang.Thread.run(Thread.java:662) [:1.6.0_24]

Exception while running jbpm-console app:

08:28:23,404 WARN [org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory] (http-localhost-127.0.0.1-8080-1) Destroying connection that is not valid, due to the following exception: oracle.jdbc.driver.T4CConnection@1fa5514: java.sql.SQLSyntaxErrorException: ORA-00923: FROM keyword not found where expected

          at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) [ojdbc6.jar:]
          at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) [ojdbc6.jar:]
          at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837) [ojdbc6.jar:]
          at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445) [ojdbc6.jar:]
          at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191) [ojdbc6.jar:]
          at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523) [ojdbc6.jar:]
          at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) [ojdbc6.jar:]
          at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:852) [ojdbc6.jar:]
          at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153) [ojdbc6.jar:]
          at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275) [ojdbc6.jar:]
          at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1890) [ojdbc6.jar:]
          at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1855) [ojdbc6.jar:]
          at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:304) [ojdbc6.jar:]
          at org.jboss.jca.adapters.jdbc.CheckValidConnectionSQL.isValidConnection(CheckValidConnectionSQL.java:74)
          at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:1151)
          at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkValid(BaseWrapperManagedConnection.java:454)
          at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.matchManagedConnections(LocalManagedConnectionFactory.java:507)
          at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:260)
          at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:392)
          at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:357)
          at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:351)
          at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:367)
          at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:467)
          at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:129)
          at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92) [hibernate-core-3.3.2.GA.jar:]
          at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51) [hibernate-core-3.3.2.GA.jar:]
          at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:168) [hibernate-core-3.3.2.GA.jar:]
          at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:356) [hibernate-core-3.3.2.GA.jar:]
          at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1341) [hibernate-core-3.3.2.GA.jar:]
          at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867) [hibernate-annotations-3.4.0.GA.jar:]
          at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669) [hibernate-entitymanager-3.4.0.GA.jar:]
          at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:126) [hibernate-entitymanager-3.4.0.GA.jar:]
          at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:63) [hibernate-jpa-2.0-api-1.0.1.Final.jar:1.0.1.Final]
          at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:47) [hibernate-jpa-2.0-api-1.0.1.Final.jar:1.0.1.Final]
          at org.jbpm.integration.console.StatefulKnowledgeSessionUtil.createOrLoadStatefulKnowledgeSession(StatefulKnowledgeSessionUtil.java:263) [jbpm-gwt-core-5.3.0.Final.jar:]
          at org.jbpm.integration.console.StatefulKnowledgeSessionUtil.initializeStatefulKnowledgeSession(StatefulKnowledgeSessionUtil.java:154) [jbpm-gwt-core-5.3.0.Final.jar:]
          at org.jbpm.integration.console.StatefulKnowledgeSessionUtil$SessionHolder.<clinit>(StatefulKnowledgeSessionUtil.java:127) [jbpm-gwt-core-5.3.0.Final.jar:]
          at org.jbpm.integration.console.StatefulKnowledgeSessionUtil.getStatefulKnowledgeSession(StatefulKnowledgeSessionUtil.java:131) [jbpm-gwt-core-5.3.0.Final.jar:]
          at org.jbpm.integration.console.SessionInitializer.<init>(SessionInitializer.java:25) [jbpm-gwt-core-5.3.0.Final.jar:]
          at org.jbpm.integration.console.TaskManagement.<init>(TaskManagement.java:51) [jbpm-gwt-core-5.3.0.Final.jar:]
          at org.jbpm.integration.console.ManagementFactory.createTaskManagement(ManagementFactory.java:26) [jbpm-gwt-core-5.3.0.Final.jar:]
          at org.jbpm.integration.console.ManagementFactory.createTaskManagement(ManagementFactory.java:19) [jbpm-gwt-core-5.3.0.Final.jar:]
          at org.jboss.bpm.console.server.TaskListFacade.getTaskManagement(TaskListFacade.java:72) [classes:]
          at org.jboss.bpm.console.server.TaskListFacade.getTasksForIdRef(TaskListFacade.java:101) [classes:]
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [:1.6.0_24]
          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [:1.6.0_24]
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [:1.6.0_24]
          at java.lang.reflect.Method.invoke(Method.java:597) [:1.6.0_24]
          at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140) [resteasy-jaxrs-2.2.1.GA.jar:]
          at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:255) [resteasy-jaxrs-2.2.1.GA.jar:]
          at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:220) [resteasy-jaxrs-2.2.1.GA.jar:]
          at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:209) [resteasy-jaxrs-2.2.1.GA.jar:]
          at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:519) [resteasy-jaxrs-2.2.1.GA.jar:]
          at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:496) [resteasy-jaxrs-2.2.1.GA.jar:]
          at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119) [resteasy-jaxrs-2.2.1.GA.jar:]
          at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208) [resteasy-jaxrs-2.2.1.GA.jar:]
          at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55) [resteasy-jaxrs-2.2.1.GA.jar:]
          at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50) [resteasy-jaxrs-2.2.1.GA.jar:]
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59) [classes:]
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:139) [jboss-as-web-7.0.2.Final.jar:7.0.2.Final]
          at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:480) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at org.jboss.as.web.NamingValve.invoke(NamingValve.java:57) [jboss-as-web-7.0.2.Final.jar:7.0.2.Final]
          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:154) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:667) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:952) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at java.lang.Thread.run(Thread.java:662) [:1.6.0_24]
Actions
5. Re: jBPM 5.3 jbpm-console problem

jnorris May 30, 2012 12:57 PM (in response to jnorris)

There are definitely issues related to the human tasks. I removed the jbpm-human-task-war.war file and started the human task service the old way using ant start.human.task. In the console I see the following exception after starting the task service:

start.human.task:
    [javac] D:\jbpm-installer\build.xml:844: warning: 'includeantruntime' was not set, defaulting to build.sysclasspath=last; set to false for repeatable builds
     [copy] Copying 1 file to D:\jbpm-installer\task-service\target
     [java] 0    30/05 12:53:33,703[main] ERROR hibernate.util.JDBCExceptionReporter.logExceptions - ORA-00942: table or view does not exist
     [java]
     [java] Exception in thread "main" javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
     [java]     at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)
     [java]     at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:76)
     [java]     at org.jbpm.task.service.persistence.TaskPersistenceManager.getUnescalatedDeadlinesList(TaskPersistenceManager.java:174)
     [java]     at org.jbpm.task.service.persistence.TaskPersistenceManager.getUnescalatedDeadlines(TaskPersistenceManager.java:146)
     [java]     at org.jbpm.task.service.TaskServiceSession.scheduleUnescalatedDeadlines(TaskServiceSession.java:231)
     [java]     at org.jbpm.task.service.TaskService.initialize(TaskService.java:116)
     [java]     at org.jbpm.task.service.TaskService.initialize(TaskService.java:101)
     [java]     at org.jbpm.task.service.TaskService.<init>(TaskService.java:79)
     [java]     at org.jbpm.DemoTaskService.main(Unknown Source)
     [java] Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
     [java]     at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
     [java]     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
     [java]     at org.hibernate.loader.Loader.doList(Loader.java:2235)
     [java]     at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
     [java]     at org.hibernate.loader.Loader.list(Loader.java:2124)
     [java]     at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
     [java]     at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
     [java]     at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
     [java]     at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149)
     [java]     at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
     [java]     at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:67)
     [java]     ... 7 more
     [java] Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
     [java]
     [java]     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
     [java]     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
     [java]     at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
     [java]     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
     [java]     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
     [java]     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
     [java]     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
     [java]     at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:863)
     [java]     at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)
     [java]     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
     [java]     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
     [java]     at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620)
     [java]     at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
     [java]     at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
     [java]     at org.hibernate.loader.Loader.getResultSet(Loader.java:1812)
     [java]     at org.hibernate.loader.Loader.doQuery(Loader.java:697)
     [java]     at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
     [java]     at org.hibernate.loader.Loader.doList(Loader.java:2232)
     [java]     ... 15 more
     [java] Java Result: 1

BUILD SUCCESSFUL
Total time: 38 seconds

I no longer get the exceptions seen with the war file during jboss startup. However when I open the jpbm-console app and select something, there are numerous exceptions thrown including the second one shown above about the From keyword. In addition there are a number of rest-easy exceptions thown such as this one:

09:14:06,951 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/gwt-console-server].[Resteasy]] (http-localhost-127.0.0.1-8080-4) Servlet.service() for servlet Resteasy threw exception: org.jboss.resteasy.spi.UnhandledException: java.lang.NoClassDefFoundError: Could not initialize class org.jbpm.integration.console.StatefulKnowledgeSessionUtil$SessionHolder
          at org.jboss.resteasy.core.SynchronousDispatcher.unwrapException(SynchronousDispatcher.java:345) [resteasy-jaxrs-2.2.1.GA.jar:]
          at org.jboss.resteasy.core.SynchronousDispatcher.handleApplicationException(SynchronousDispatcher.java:321) [resteasy-jaxrs-2.2.1.GA.jar:]
          at org.jboss.resteasy.core.SynchronousDispatcher.handleException(SynchronousDispatcher.java:214) [resteasy-jaxrs-2.2.1.GA.jar:]
          at org.jboss.resteasy.core.SynchronousDispatcher.handleInvokerException(SynchronousDispatcher.java:190) [resteasy-jaxrs-2.2.1.GA.jar:]
          at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:534) [resteasy-jaxrs-2.2.1.GA.jar:]
          at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:496) [resteasy-jaxrs-2.2.1.GA.jar:]
          at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119) [resteasy-jaxrs-2.2.1.GA.jar:]
          at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208) [resteasy-jaxrs-2.2.1.GA.jar:]
          at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55) [resteasy-jaxrs-2.2.1.GA.jar:]
          at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50) [resteasy-jaxrs-2.2.1.GA.jar:]
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59) [classes:]
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:139) [jboss-as-web-7.0.2.Final.jar:7.0.2.Final]
          at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:480) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at org.jboss.as.web.NamingValve.invoke(NamingValve.java:57) [jboss-as-web-7.0.2.Final.jar:7.0.2.Final]
          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:154) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:667) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:952) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
          at java.lang.Thread.run(Thread.java:662) [:1.6.0_24]
Caused by: java.lang.NoClassDefFoundError: Could not initialize class org.jbpm.integration.console.StatefulKnowledgeSessionUtil$SessionHolder
          at org.jbpm.integration.console.StatefulKnowledgeSessionUtil.getStatefulKnowledgeSession(StatefulKnowledgeSessionUtil.java:131) [jbpm-gwt-core-5.3.0.Final.jar:]
          at org.jbpm.integration.console.SessionInitializer.<init>(SessionInitializer.java:25) [jbpm-gwt-core-5.3.0.Final.jar:]
          at org.jbpm.integration.console.ProcessManagement.<init>(ProcessManagement.java:38) [jbpm-gwt-core-5.3.0.Final.jar:]
          at org.jbpm.integration.console.ManagementFactory.createProcessManagement(ManagementFactory.java:22) [jbpm-gwt-core-5.3.0.Final.jar:]
          at org.jbpm.integration.console.ManagementFactory.createProcessManagement(ManagementFactory.java:19) [jbpm-gwt-core-5.3.0.Final.jar:]
          at org.jboss.bpm.console.server.ProcessMgmtFacade.getProcessManagement(ProcessMgmtFacade.java:89) [classes:]
          at org.jboss.bpm.console.server.ProcessMgmtFacade.getDefinitionsJSON(ProcessMgmtFacade.java:125) [classes:]
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [:1.6.0_24]
          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [:1.6.0_24]
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [:1.6.0_24]
          at java.lang.reflect.Method.invoke(Method.java:597) [:1.6.0_24]
          at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140) [resteasy-jaxrs-2.2.1.GA.jar:]
          at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:255) [resteasy-jaxrs-2.2.1.GA.jar:]
          at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:220) [resteasy-jaxrs-2.2.1.GA.jar:]
          at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:209) [resteasy-jaxrs-2.2.1.GA.jar:]
          at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:519) [resteasy-jaxrs-2.2.1.GA.jar:]
          ... 24 more
Actions
6. Re: jBPM 5.3 jbpm-console problem

swiderski.maciej May 31, 2012 1:21 AM (in response to triathlon98)

Yes, there was an issue with one of the queries so you can either 1. get latest version of the human task core (5.4.0-SNAPSHOT) or modify taskorm.xml file as a workaround. That affects Group tasks tab in console as far as I know.
Actions
7. Re: jBPM 5.3 jbpm-console problem

swiderski.maciej May 31, 2012 1:35 AM (in response to jnorris)

second issue take a look at my previous post.

for the first one, would be great if you clear the logs and start the server once again and upload full server log here for analysis. As the exception does not really make sense (ORA-00923: FROM keyword not found where expected).

The other exception with class not found is probably caused by not able to connect to task server as it expects hornetq service to be listening on localhost:5445. Human task war starts hornetq service on 5445 port and ant task starts human task standalone with Mina.
Actions
8. Re: jBPM 5.3 jbpm-console problem

jnorris May 31, 2012 8:10 AM (in response to swiderski.maciej)
Hi Maciej,

As you requested, I cleared the server log file and restarted jboss with the jbpm-human-task-war.war file deployed. All edited installer files and the server log files are in the attached zip file except the server name and sid in the db url are changed from the actual ones used.

Regards,
Jim

jbpm5.zip 36.6 KB
Actions
9. Re: jBPM 5.3 jbpm-console problem

swiderski.maciej May 31, 2012 1:34 PM (in response to jnorris)

I think the problem is with your data source configuration in standalone.xml - there is an sql statement given which I think is not valid "SELECT 1" and thus the error ORA-00923: FROM keyword not found where expected.

Same probably happens when you undeploy task server war and try to use console only as console with build EntityManagerFactory on first access not as human task war which does that on server startup.

HTH
Actions
10. Re: jBPM 5.3 jbpm-console problem

jnorris May 31, 2012 1:39 PM (in response to swiderski.maciej)

Thanks Maciej,

I didn't notice that when following the changes to make to change the DB in the user guide. I'll add that tidbit to the jira issue I created for the documentation of changing the DB used. Hopefully that and the changes to taskorm.xml will resolve the console issues.

Regards,
Jim
Actions
11. Re: jBPM 5.3 jbpm-console problem

swiderski.maciej May 31, 2012 1:44 PM (in response to jnorris)

Goodie, let me know how it went, and if that is not the case we'll dig more into that

btw, thanks for the jira and perfect log/config extract, helped a lot to trace it.

Cheers
Actions
12. Re: jBPM 5.3 jbpm-console problem

jnorris May 31, 2012 2:17 PM (in response to swiderski.maciej)
Still no go although the datasource exceptions are fixed now (changed SELECT 1 to SELECT NULL FROM DUAL). I attached the server.log file which shows some exceptions. The first one that shows up is

Caused by: java.io.InvalidClassException: org.drools.rule.MVELDialectRuntimeData; local class incompatible: stream classdesc serialVersionUID = 5166066541265170937, local class serialVersionUID = -64624826351992706

I also found this one:

14:03:02,281 ERROR [stderr] (Thread-17) java.lang.IllegalArgumentException: Named query not found: TasksAssignedAsPotentialOwnerByStatusByGroup

The TaskORM.xml file in the jbpm-human-task-core-5.3.0.Final.jar in the war file has been replaced with the one out of the latest 5.4.0 snapshot.

serverLog.zip 11.3 KB
Actions
13. Re: jBPM 5.3 jbpm-console problem

swiderski.maciej Jun 1, 2012 6:56 AM (in response to jnorris)
Jim, please use orm file that I attached to this post. As in that one from master there were some code changes as well.

Regarding this serialization issue, do you get process definitions from Guvnor? If so, do you run the one that comes with 5.3? And do you run them in the same server if not make sure you run them on the same jvm version. And any way rebuild you packages in Guvnor prioor to running them in console.

HTH

Taskorm.xml 25.2 KB
Actions
14. Re: jBPM 5.3 jbpm-console problem

melc Jun 1, 2012 7:20 AM (in response to jnorris)

Hello,
I think you may also need to replace class
org.jbpm.task.service.TaskServiceSession

check out this thread it is related to this issue,
https://community.jboss.org/message/738335#738335
Actions

1 2 3 4 Previous Next

Go to original post