jBPM 6.0 CR2 problems using Postgresql database
bartsimp Oct 31, 2013 11:22 AMHi, I'm trying to configure and use the new jBPM console and dashboard using the postgresql database.
The application start and the db tables are created successfully.
BUT I got many differents errors.
example error 1:
on deploy I got this query fail due to the AS keyword mandatory in postgresql
15:09:30,634 ERROR [org.jboss.dashboard.dataset.sql.SQLDataSet] (MSC service thread 1-6) Error in load() SQLDataset. SQL = select total.processname, coalesce(total.instances,0) total, coalesce(active.instances_act,0) active, coalesce(completed.instances_compl,0) completed, coalesce(pending.instances_pend,0) pending, coalesce(suspended.instances_susp,0) suspended, coalesce(aborted.instances_abrt,0) aborted
from
(select pi.processinstanceid as pId, pi.processname as processname, count(*) as instances
from processinstancelog pi group by pi.processinstanceid,processname) as total
left outer join
(select pi.processinstanceid as pId, count(*) as instances_act
from processinstancelog pi
where pi.status=1 group by pi.processinstanceid) as active
on (total.pId=active.pId)
left outer join
(select pi.processinstanceid as pId, count(*) as instances_compl
from processinstancelog pi
where pi.status=2 group by pi.processinstanceid) as completed
on (total.pId=completed.pId)
left outer join
(select pi.processinstanceid as pId, count(*) as instances_pend
from processinstancelog pi
where pi.status=0 group by pi.processinstanceid) as pending
on (total.pId=pending.pId)
left outer join
(select pi.processinstanceid as pId, count(*) as instances_susp
from processinstancelog pi
where pi.status=4 group by pi.processinstanceid) as suspended
on (total.pId=suspended.pId)
left outer join
(select pi.processinstanceid as pId, count(*) as instances_abrt
from processinstancelog pi
where pi.status=3 group by pi.processinstanceid) as aborted
on (total.pId=aborted.pId)
where 1 = 1
order by processname
: org.postgresql.util.PSQLException: ERROR: syntax error at or near "total"
example error 2:
16:11:23,684 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-0.0.0.0-0.0.0.0-8080-2) ERROR: column "rulesbytearray" is of type oid but expression is of type bytea
example error 3:
Log in the system with the krisv user.
Click on Authoring -> Project Authoring
Select demo -> jbpm-playground -> async-examples -> check weather
Click on Tools -> Project Editor
The webapp freeze and I got this exception in log file:
The same operation using H2 database works fine
15:47:44,317 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) org.jboss.errai.bus.client.api.base.MessageDeliveryFailure: error invoking endpoint
15:47:44,317 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.jboss.errai.bus.server.io.ConversationalEndpointCallback.callback(ConversationalEndpointCallback.java:132)
15:47:44,317 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.jboss.errai.bus.server.io.RemoteServiceCallback.callback(RemoteServiceCallback.java:54)
15:47:44,317 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.jboss.errai.cdi.server.CDIExtensionPoints$3.callback(CDIExtensionPoints.java:512)
15:47:44,327 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.jboss.errai.bus.client.framework.DeliveryPlan.deliver(DeliveryPlan.java:43)
15:47:44,327 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.jboss.errai.bus.server.ServerMessageBusImpl.sendGlobal(ServerMessageBusImpl.java:632)
15:47:44,327 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.jboss.errai.bus.server.SimpleDispatcher.dispatchGlobal(SimpleDispatcher.java:46)
15:47:44,327 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.jboss.errai.bus.server.service.ErraiServiceImpl.store(ErraiServiceImpl.java:93)
15:47:44,337 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.jboss.errai.bus.server.service.ErraiServiceImpl.store(ErraiServiceImpl.java:107)
15:47:44,337 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.jboss.errai.bus.server.servlet.DefaultBlockingServlet.doPost(DefaultBlockingServlet.java:117)
15:47:44,337 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)
15:47:44,337 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
15:47:44,347 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
15:47:44,347 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
15:47:44,347 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.jboss.weld.servlet.ConversationPropagationFilter.doFilter(ConversationPropagationFilter.java:62)
15:47:44,347 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
15:47:44,357 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
15:47:44,357 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.jboss.solder.servlet.exception.CatchExceptionFilter.doFilter(CatchExceptionFilter.java:65)
15:47:44,357 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
15:47:44,367 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
15:47:44,367 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.jboss.solder.servlet.event.ServletEventBridgeFilter.doFilter(ServletEventBridgeFilter.java:74)
15:47:44,367 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
15:47:44,367 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
15:47:44,377 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.jbpm.designer.web.filter.impl.PluggableFilter.doFilter(PluggableFilter.java:70)
15:47:44,377 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
15:47:44,377 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
15:47:44,377 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.uberfire.security.server.UberFireSecurityFilter.doFilter(UberFireSecurityFilter.java:266)
15:47:44,387 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
15:47:44,387 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
15:47:44,387 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
15:47:44,387 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
15:47:44,397 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:489)
15:47:44,397 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50)
15:47:44,397 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153)
15:47:44,407 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)
15:47:44,407 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
15:47:44,407 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:416)
15:47:44,407 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
15:47:44,417 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368)
15:47:44,417 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)
15:47:44,417 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671)
15:47:44,417 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930)
15:47:44,417 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at java.lang.Thread.run(Thread.java:662)
15:47:44,427 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) Caused by: org.guvnor.common.services.shared.exceptions.GenericPortableException: org.uberfire.java.nio.base.Properties
15:47:44,427 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.guvnor.common.services.backend.exceptions.ExceptionUtilities.handleException(ExceptionUtilities.java:24)
15:47:44,427 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.guvnor.common.services.backend.metadata.MetadataServiceImpl.getMetadata(MetadataServiceImpl.java:97)
15:47:44,437 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.guvnor.common.services.backend.metadata.MetadataServiceImpl$Proxy$_$$_WeldClientProxy.getMetadata(MetadataServiceImpl$Proxy$_$$_WeldClientProxy.java)
15:47:44,437 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.kie.workbench.common.screens.projecteditor.backend.server.ProjectScreenServiceImpl.load(ProjectScreenServiceImpl.java:50)
15:47:44,437 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.kie.workbench.common.screens.projecteditor.backend.server.ProjectScreenServiceImpl$Proxy$_$$_WeldClientProxy.load(ProjectScreenServiceImpl$Proxy$_$$_WeldClientProxy.java)
15:47:44,447 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
15:47:44,447 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
15:47:44,447 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
15:47:44,447 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at java.lang.reflect.Method.invoke(Method.java:597)
15:47:44,457 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) at org.jboss.errai.bus.server.io.ConversationalEndpointCallback.callback(ConversationalEndpointCallback.java:114)
15:47:44,457 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) ... 41 more
15:47:44,457 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) *** Message delivery failure ***
15:47:44,457 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) Bus: org.jboss.errai.bus.server.ServerMessageBusImpl@7ae3b5d2
15:47:44,457 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) Message: CommandType=load:org.uberfire.backend.vfs.Path:, ErrorTo=org.kie.workbench.common.screens.projecteditor.service.ProjectScreenService:RPC.load:org.uberfire.backend.vfs.Path::Errors:34, ReplyTo=org.kie.workbench.common.screens.projecteditor.service.ProjectScreenService:RPC.load:org.uberfire.backend.vfs.Path::RespondTo:34, ToSubject=org.kie.workbench.common.screens.projecteditor.service.ProjectScreenService:RPC, MethodParms=[PathImpl{uri='default://master@jbpm-playground/async-examples/pom.xml', fileName='pom.xml', attrs={}}]
15:47:44,467 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) errorMessage: Error calling remote service: org.kie.workbench.common.screens.projecteditor.service.ProjectScreenService:RPC
15:47:44,477 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) exception: org.jboss.errai.bus.client.api.base.MessageDeliveryFailure: error invoking endpoint
15:47:44,477 ERROR [stderr] (http-0.0.0.0-0.0.0.0-8080-5) disconnect: false