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

      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

          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.

          • 2. Re: jBPM 5.3 jbpm-console problem
            swiderski.maciej

            Could you please upload your server.log?

             

            Cheers

            • 3. Re: jBPM 5.3 jbpm-console problem
              triathlon98

              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

              • 4. Re: jBPM 5.3 jbpm-console problem
                jnorris

                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]

                • 5. Re: jBPM 5.3 jbpm-console problem
                  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

                  • 6. Re: jBPM 5.3 jbpm-console problem
                    swiderski.maciej

                    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.

                    • 7. Re: jBPM 5.3 jbpm-console problem
                      swiderski.maciej

                      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.

                      • 8. Re: jBPM 5.3 jbpm-console problem
                        jnorris

                        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

                        • 9. Re: jBPM 5.3 jbpm-console problem
                          swiderski.maciej

                          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

                          • 10. Re: jBPM 5.3 jbpm-console problem
                            jnorris

                            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

                            • 11. Re: jBPM 5.3 jbpm-console problem
                              swiderski.maciej

                              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

                              • 12. Re: jBPM 5.3 jbpm-console problem
                                jnorris

                                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.

                                • 13. Re: jBPM 5.3 jbpm-console problem
                                  swiderski.maciej

                                  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

                                  • 14. Re: jBPM 5.3 jbpm-console problem
                                    melc

                                    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

                                    1 2 3 4 Previous Next