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

    jBPM 6.0 CR2 problems using Postgresql database

    Luigi R Newbie

      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