2 Replies Latest reply on Nov 4, 2013 9:11 AM by bartsimp

    jBPM 6.0 CR2 problems using Postgresql database

    bartsimp

      Hi, 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