3 Replies Latest reply on Aug 22, 2012 10:59 AM by Tom Eugelink

    getting started; screencasts do not match my screens

    Tom Eugelink Newbie

      I'm currently working through the getting started examples (Eclipse and console) but I'm not seeing what is shown in the screen casts.

      Eclipse: even though I can start a process, selecting the session variable does not not show it in the "process instances" view.

      Console: even though I can start a process, enter the correct username (krisv) and see a running process; it does not show up in my (krisv) tasks.

       

      Anyone care to guess what I'm doing wrong?

        • 1. Re: getting started; screencasts do not match my screens
          Tom Eugelink Newbie

          To top it off; the "Using your own database with jBPM' quick start also crashes and burns. I've set it up using Postgres, there are a bunch of tables in the two databases, but the console is not started (JBoss7 itself is):

           

          16:25:05,579 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/jbpm-human-task-war]] (MSC service thread 1-3) StandardWrapper.Throwable: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query

                    at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614) [hibernate-entitymanager-3.4.0.GA.jar:]

                    at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:76) [hibernate-entitymanager-3.4.0.GA.jar:]

                    at org.jbpm.task.service.persistence.TaskPersistenceManager.getUnescalatedDeadlinesList(TaskPersistenceManager.java:174) [jbpm-human-task-core-5.3.0.Final.jar:]

                    at org.jbpm.task.service.persistence.TaskPersistenceManager.getUnescalatedDeadlines(TaskPersistenceManager.java:146) [jbpm-human-task-core-5.3.0.Final.jar:]

                    at org.jbpm.task.service.TaskServiceSession.scheduleUnescalatedDeadlines(TaskServiceSession.java:231) [jbpm-human-task-core-5.3.0.Final.jar:]

                    at org.jbpm.task.service.TaskService.initialize(TaskService.java:116) [jbpm-human-task-core-5.3.0.Final.jar:]

                    at org.jbpm.task.service.TaskService.initialize(TaskService.java:101) [jbpm-human-task-core-5.3.0.Final.jar:]

                    at org.jbpm.task.service.TaskService.<init>(TaskService.java:79) [jbpm-human-task-core-5.3.0.Final.jar:]

                    at org.jbpm.task.servlet.HumanTaskServiceServlet.init(HumanTaskServiceServlet.java:127) [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.runWorker(ThreadPoolExecutor.java:1110) [:1.7.0_04]

                    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [:1.7.0_04]

                    at java.lang.Thread.run(Thread.java:722) [:1.7.0_04]

          Caused by: org.hibernate.exception.SQLGrammarException: could not execute query

                    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90) [hibernate-core-3.3.2.GA.jar:]

                    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) [hibernate-core-3.3.2.GA.jar:]

                    at org.hibernate.loader.Loader.doList(Loader.java:2235) [hibernate-core-3.3.2.GA.jar:]

                    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129) [hibernate-core-3.3.2.GA.jar:]

                    at org.hibernate.loader.Loader.list(Loader.java:2124) [hibernate-core-3.3.2.GA.jar:]

                    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401) [hibernate-core-3.3.2.GA.jar:]

                    at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363) [hibernate-core-3.3.2.GA.jar:]

                    at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) [hibernate-core-3.3.2.GA.jar:]

                    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149) [hibernate-core-3.3.2.GA.jar:]

                    at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) [hibernate-core-3.3.2.GA.jar:]

                    at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:67) [hibernate-entitymanager-3.4.0.GA.jar:]

                    ... 18 more

          Caused by: org.postgresql.util.PSQLException: ERROR: relation "task" does not exist

            Position: 100

                    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101)

                    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834)

                    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)

                    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)

                    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386)

                    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)

                    at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)

                    at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) [hibernate-core-3.3.2.GA.jar:]

                    at org.hibernate.loader.Loader.getResultSet(Loader.java:1812) [hibernate-core-3.3.2.GA.jar:]

                    at org.hibernate.loader.Loader.doQuery(Loader.java:697) [hibernate-core-3.3.2.GA.jar:]

                    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259) [hibernate-core-3.3.2.GA.jar:]

                    at org.hibernate.loader.Loader.doList(Loader.java:2232) [hibernate-core-3.3.2.GA.jar:]

                    ... 26 more

           

           

          16:25:05,736 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/jbpm-human-task-war]] (MSC service thread 1-3) Servlet /jbpm-human-task-war threw load() exception: org.postgresql.util.PSQLException: ERROR: relation "task" does not exist

            Position: 100

                    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101)

                    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834)

                    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)

                    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)

                    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386)

                    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)

                    at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)

                    at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) [hibernate-core-3.3.2.GA.jar:]

                    at org.hibernate.loader.Loader.getResultSet(Loader.java:1812) [hibernate-core-3.3.2.GA.jar:]

                    at org.hibernate.loader.Loader.doQuery(Loader.java:697) [hibernate-core-3.3.2.GA.jar:]

                    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259) [hibernate-core-3.3.2.GA.jar:]

                    at org.hibernate.loader.Loader.doList(Loader.java:2232) [hibernate-core-3.3.2.GA.jar:]

                    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129) [hibernate-core-3.3.2.GA.jar:]

                    at org.hibernate.loader.Loader.list(Loader.java:2124) [hibernate-core-3.3.2.GA.jar:]

                    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401) [hibernate-core-3.3.2.GA.jar:]

                    at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363) [hibernate-core-3.3.2.GA.jar:]

                    at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) [hibernate-core-3.3.2.GA.jar:]

                    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149) [hibernate-core-3.3.2.GA.jar:]

                    at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) [hibernate-core-3.3.2.GA.jar:]

                    at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:67) [hibernate-entitymanager-3.4.0.GA.jar:]

                    at org.jbpm.task.service.persistence.TaskPersistenceManager.getUnescalatedDeadlinesList(TaskPersistenceManager.java:174) [jbpm-human-task-core-5.3.0.Final.jar:]

                    at org.jbpm.task.service.persistence.TaskPersistenceManager.getUnescalatedDeadlines(TaskPersistenceManager.java:146) [jbpm-human-task-core-5.3.0.Final.jar:]

                    at org.jbpm.task.service.TaskServiceSession.scheduleUnescalatedDeadlines(TaskServiceSession.java:231) [jbpm-human-task-core-5.3.0.Final.jar:]

                    at org.jbpm.task.service.TaskService.initialize(TaskService.java:116) [jbpm-human-task-core-5.3.0.Final.jar:]

                    at org.jbpm.task.service.TaskService.initialize(TaskService.java:101) [jbpm-human-task-core-5.3.0.Final.jar:]

                    at org.jbpm.task.service.TaskService.<init>(TaskService.java:79) [jbpm-human-task-core-5.3.0.Final.jar:]

                    at org.jbpm.task.servlet.HumanTaskServiceServlet.init(HumanTaskServiceServlet.java:127) [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.runWorker(ThreadPoolExecutor.java:1110) [:1.7.0_04]

                    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [:1.7.0_04]

                    at java.lang.Thread.run(Thread.java:722) [:1.7.0_04]

           

           

          Going to merge the two databases, see what happens.

          • 2. Re: getting started; screencasts do not match my screens
            Tom Eugelink Newbie

            Ok, merging the two databases solved that last issue. JBoss now boots correctly. So the part of two databases in the getting started manual should be confirmed that it still works.

            But I now get another exception when trying to create a workflow in the console (like I did before on the H2 database). This could be https://bugzilla.redhat.com/show_bug.cgi?id=805899

             

            org.jboss.resteasy.spi.UnhandledException: java.lang.RuntimeException: Could not commit session or rollback

                      org.jboss.resteasy.core.SynchronousDispatcher.unwrapException(SynchronousDispatcher.java:345)

                      org.jboss.resteasy.core.SynchronousDispatcher.handleApplicationException(SynchronousDispatcher.java:321)

                      org.jboss.resteasy.core.SynchronousDispatcher.handleException(SynchronousDispatcher.java:214)

                      org.jboss.resteasy.core.SynchronousDispatcher.handleInvokerException(SynchronousDispatcher.java:190)

                      org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:534)

                      org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:496)

                      org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119)

                      org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)

                      org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)

                      org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)

                      javax.servlet.http.HttpServlet.service(HttpServlet.java:847)

                      org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)

            root cause

             

             

            java.lang.RuntimeException: Could not commit session or rollback

                      org.drools.persistence.SingleSessionCommandService.rollbackTransaction(SingleSessionCommandService.java:401)

                      org.drools.persistence.SingleSessionCommandService.execute(SingleSessionCommandService.java:376)

                      org.drools.command.impl.CommandBasedStatefulKnowledgeSession.startProcess(CommandBasedStatefulKnowledgeSession.java:223)

                      org.jbpm.integration.console.CommandDelegate.startProcess(CommandDelegate.java:120)

                      org.jbpm.integration.console.ProcessManagement.newInstance(ProcessManagement.java:88)

                      org.jboss.bpm.console.server.FormProcessingFacade.startProcessWithUI(FormProcessingFacade.java:197)

                      sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                      sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

                      sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

                      java.lang.reflect.Method.invoke(Method.java:601)

                      org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)

                      org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:255)

                      org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:220)

                      org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:209)

                      org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:519)

                      org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:496)

                      org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119)

                      org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)

                      org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)

                      org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)

                      javax.servlet.http.HttpServlet.service(HttpServlet.java:847)

                      org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)

            root cause

             

             

            java.lang.RuntimeException: Unable to rollback transaction

                      org.drools.persistence.jta.JtaTransactionManager.rollback(JtaTransactionManager.java:197)

                      org.drools.persistence.SingleSessionCommandService.rollbackTransaction(SingleSessionCommandService.java:397)

                      org.drools.persistence.SingleSessionCommandService.execute(SingleSessionCommandService.java:376)

                      org.drools.command.impl.CommandBasedStatefulKnowledgeSession.startProcess(CommandBasedStatefulKnowledgeSession.java:223)

                      org.jbpm.integration.console.CommandDelegate.startProcess(CommandDelegate.java:120)

                      org.jbpm.integration.console.ProcessManagement.newInstance(ProcessManagement.java:88)

                      org.jboss.bpm.console.server.FormProcessingFacade.startProcessWithUI(FormProcessingFacade.java:197)

                      sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                      sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

                      sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

                      java.lang.reflect.Method.invoke(Method.java:601)

                      org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)

                      org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:255)

                      org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:220)

                      org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:209)

                      org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:519)

                      org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:496)

                      org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119)

                      org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)

                      org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)

                      org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)

                      javax.servlet.http.HttpServlet.service(HttpServlet.java:847)

                      org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)

            root cause

             

             

            java.lang.IllegalStateException: BaseTransaction.rollback - no transaction!

                      com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.rollback(BaseTransaction.java:132)

                      org.drools.persistence.jta.JtaTransactionManager.rollback(JtaTransactionManager.java:191)

                      org.drools.persistence.SingleSessionCommandService.rollbackTransaction(SingleSessionCommandService.java:397)

                      org.drools.persistence.SingleSessionCommandService.execute(SingleSessionCommandService.java:376)

                      org.drools.command.impl.CommandBasedStatefulKnowledgeSession.startProcess(CommandBasedStatefulKnowledgeSession.java:223)

                      org.jbpm.integration.console.CommandDelegate.startProcess(CommandDelegate.java:120)

                      org.jbpm.integration.console.ProcessManagement.newInstance(ProcessManagement.java:88)

                      org.jboss.bpm.console.server.FormProcessingFacade.startProcessWithUI(FormProcessingFacade.java:197)

                      sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                      sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

                      sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

                      java.lang.reflect.Method.invoke(Method.java:601)

                      org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)

                      org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:255)

                      org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:220)

                      org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:209)

                      org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:519)

                      org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:496)

                      org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119)

                      org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)

                      org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)

                      org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)

                      javax.servlet.http.HttpServlet.service(HttpServlet.java:847)

                      org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)

            • 3. Re: getting started; screencasts do not match my screens
              Tom Eugelink Newbie

              This happens with every attempt to start the "evaluation" workflow, but the "hello" workflow has no problems.

               

              Next topic: after setting postgres as the database, the getting started says to do a clean.demo and then an install.demo.db and start.demo.db. This results in the Eclipse no longer being present. After some research in build.xml I found that eclipse is left out on purpose and that in a separate DOS window I need to do a "install.eclipse" and the "start.eclipse". Why would Eclipse not be needed in this scenario?