8:59 a.m.
Tom Eugelink [https://community.jboss.org/people/tbee] created the discussion
"getting started; screencasts do not match my screens"
To view the discussion, visit: https://community.jboss.org/message/755146#755146
--------------------------------------------------------------
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?
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/755146#755146]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&...]
9:30 a.m.
New subject: [jBPM] - Re: getting started; screencasts do not match my screens
Tom Eugelink [https://community.jboss.org/people/tbee] created the discussion
"Re: getting started; screencasts do not match my screens"
To view the discussion, visit: https://community.jboss.org/message/755162#755162
--------------------------------------------------------------
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.
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/755162#755162]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&...]
9:42 a.m.
New subject: [jBPM] - Re: getting started; screencasts do not match my screens
Tom Eugelink [https://community.jboss.org/people/tbee] created the discussion
"Re: getting started; screencasts do not match my screens"
To view the discussion, visit: https://community.jboss.org/message/755166#755166
--------------------------------------------------------------
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).
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)
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/755166#755166]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&...]
5077
days inactive
5077
days old
2 comments
1 participants
participants (1)
-
Tom Eugelink