-
Bug
-
Resolution: Done
-
Blocker
-
None
-
6.0.1
-
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.