Uploaded image for project: 'JBoss BPMS Platform'
  1. JBoss BPMS Platform
  2. RHBPMS-758

Blank page accessing "Business Dashboards" with EnterpriseDB

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Blocker Blocker
    • None
    • 6.0.1
    • BAM
    • All All

      Description of problem:

      If you install BPM Suite with EnterpriseDB as underlying database and you try to access to Dashboards -> Business Dashboards then a blank page is open and the log shows the next error:

      17:01:53,359 ERROR [org.jboss.dashboard.error.ErrorManager] (http-localhost/127.0.0.1:8080-6) UNEXPECTED ERROR.
      Thread id=http-localhost/127.0.0.1:8080-6
      Thread begin date=Tue Jul 01 17:01:53 CEST 2014
      Thread group=main
      Request URL=/dashbuilder/workspace/en/showcase
      Request IP=127.0.0.1
      Request date=Tue Jul 01 17:01:53 CEST 2014
      Request header:user-agent=Mozilla/5.0 (X11; Linux x86_64; rv:30.0) Gecko/20100101 Firefox/30.0
      Request header:referer=http://localhost:8080/business-central/org.kie.workbench.KIEWebapp/66B7FE766FBC11FFB6033691A0AB1BA0.cache.html
      Request header:cookie=JSESSIONID=WNGAY2gL4YKvy6L6hGT-6DL9; __utma=111872281.1245142237.1397404614.1397427018.1398415658.3; __utmz=111872281.1397404614.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); JSESSIONIDSSO=0RF3n1LMjZMgteNbfQJfdpXI
      Error id=1404226913357
      Error date=Tue Jul 01 17:01:53 CEST 2014
      Error stack trace=java.lang.NullPointerException
      at org.jboss.dashboard.database.hibernate.HibernateTransaction.begin(HibernateTransaction.java:142)
      at org.jboss.dashboard.database.hibernate.HibernateTxFragment.executeInitiator(HibernateTxFragment.java:174)
      at org.jboss.dashboard.database.hibernate.HibernateTxFragment.execute(HibernateTxFragment.java:167)
      at org.jboss.dashboard.ui.controller.ControllerServlet.processTheRequest(ControllerServlet.java:187)
      at org.jboss.dashboard.ui.controller.ControllerServlet$2.doWork(ControllerServlet.java:166)
      at org.jboss.dashboard.factory.Factory.runWork(Factory.java:295)
      at org.jboss.dashboard.factory.Factory.doWork(Factory.java:321)
      at org.jboss.dashboard.ui.controller.ControllerServlet.service(ControllerServlet.java:148)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
      at sun.reflect.GeneratedMethodAccessor41.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:606)
      at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:263)
      at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:261)
      at java.security.AccessController.doPrivileged(Native Method)
      at javax.security.auth.Subject.doAsPrivileged(Subject.java:536)
      at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:295)
      at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:155)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:288)
      at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:59)
      at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:197)
      at java.security.AccessController.doPrivileged(Native Method)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149)
      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:499)
      at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97)
      at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:408)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:336)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:920)
      at java.lang.Thread.run(Thread.java:744)

      17:01:53,365 ERROR [org.jboss.dashboard.ui.controller.ControllerServlet] (http-localhost/127.0.0.1:8080-6) Error painting response.

      Version-Release number of selected component (if applicable):

      Red Hat JBoss BPM Suite 6.0.1

      How reproducible:

      1. Install BPMS 6.0.1 with EnterpriseDB as underlying database
      2. Login in http://localhost:8080/business-central
      3. Go to Dashboards -> Business Dashboards

      Steps to Reproduce:
      1. Install BPMS 6.0.1 with EnterpriseDB as underlying database
      2. Login in http://localhost:8080/business-central
      3. Go to Dashboards -> Business Dashboards

      Actual results:

      Blank page is open and the log shows the next error:

      17:01:53,359 ERROR [org.jboss.dashboard.error.ErrorManager] (http-localhost/127.0.0.1:8080-6) UNEXPECTED ERROR.
      Thread id=http-localhost/127.0.0.1:8080-6
      Thread begin date=Tue Jul 01 17:01:53 CEST 2014
      Thread group=main
      Request URL=/dashbuilder/workspace/en/showcase
      Request IP=127.0.0.1
      Request date=Tue Jul 01 17:01:53 CEST 2014
      Request header:user-agent=Mozilla/5.0 (X11; Linux x86_64; rv:30.0) Gecko/20100101 Firefox/30.0
      Request header:referer=http://localhost:8080/business-central/org.kie.workbench.KIEWebapp/66B7FE766FBC11FFB6033691A0AB1BA0.cache.html
      Request header:cookie=JSESSIONID=WNGAY2gL4YKvy6L6hGT-6DL9; __utma=111872281.1245142237.1397404614.1397427018.1398415658.3; __utmz=111872281.1397404614.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); JSESSIONIDSSO=0RF3n1LMjZMgteNbfQJfdpXI
      Error id=1404226913357
      Error date=Tue Jul 01 17:01:53 CEST 2014
      Error stack trace=java.lang.NullPointerException
      at org.jboss.dashboard.database.hibernate.HibernateTransaction.begin(HibernateTransaction.java:142)
      at org.jboss.dashboard.database.hibernate.HibernateTxFragment.executeInitiator(HibernateTxFragment.java:174)
      at org.jboss.dashboard.database.hibernate.HibernateTxFragment.execute(HibernateTxFragment.java:167)
      at org.jboss.dashboard.ui.controller.ControllerServlet.processTheRequest(ControllerServlet.java:187)
      at org.jboss.dashboard.ui.controller.ControllerServlet$2.doWork(ControllerServlet.java:166)
      at org.jboss.dashboard.factory.Factory.runWork(Factory.java:295)
      at org.jboss.dashboard.factory.Factory.doWork(Factory.java:321)
      at org.jboss.dashboard.ui.controller.ControllerServlet.service(ControllerServlet.java:148)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
      at sun.reflect.GeneratedMethodAccessor41.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:606)
      at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:263)
      at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:261)
      at java.security.AccessController.doPrivileged(Native Method)
      at javax.security.auth.Subject.doAsPrivileged(Subject.java:536)
      at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:295)
      at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:155)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:288)
      at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:59)
      at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:197)
      at java.security.AccessController.doPrivileged(Native Method)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149)
      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:499)
      at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97)
      at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:408)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:336)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:920)
      at java.lang.Thread.run(Thread.java:744)

      17:01:53,365 ERROR [org.jboss.dashboard.ui.controller.ControllerServlet] (http-localhost/127.0.0.1:8080-6) Error painting response.

      Expected results:

      Open the Dashboards -> Business Dashboards page without errors.

      Additional info:

      In org.jboss.dashboard.database.hibernate.HibernateInitializer its method inferDatabaseName have this:

      String dbProductName = connection.getMetaData().getDatabaseProductName().toLowerCase();
      if (dbProductName.contains("h2")) return DB_H2;
      if (dbProductName.contains("postgre")) return DB_POSTGRES;
      if (dbProductName.contains("mysql")) return DB_MYSQL;
      if (dbProductName.contains("oracle")) return DB_ORACLE;

      I guess that this driver's metadata gives a different product name.

      I have attached the EnterpriseDB jdbc driver.

              jschatte@redhat.com Jan Schatteman
              rhn-support-omolinab Oscar Molina
              Jan Hrcek Jan Hrcek (Inactive)
              Jan Hrcek Jan Hrcek (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: