Hitachi Vantara Pentaho Community Forums
Results 1 to 9 of 9

Thread: Pentaho ce 5 Initialization Exception

  1. #1

    Default Pentaho ce 5 Initialization Exception

    Hi, I'm trying to start my pentaho ce 5.0.1 installation, but an error shows up:

    Pentaho Initialization Exception

    The following errors were detected
    [pt_49] One or more system listeners failed. These are set in the systemListeners.xml.
    org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 - [pt_71] Error while trying to execute startup sequence for org.pentaho.platform.scheduler2.quartz.EmbeddedQuartzSystemListener

    Please see the server console for more details on each error detected.

    The catalina.out have the following error:

    13:03:23,683 ERROR [EmbeddedQuartzSystemListener] EmbeddedQuartzSystemListener.ERROR_0007_SQLERROR
    org.postgresql.util.PSQLException: ERROR: syntax error at or near "RUNSCRIPT"
    Position: 1
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:372)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:300)
    at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
    at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
    at org.pentaho.platform.scheduler2.quartz.EmbeddedQuartzSystemListener.verifyQuartzIsConfigured(EmbeddedQuartzSystemListener.java:159)
    at org.pentaho.platform.scheduler2.quartz.EmbeddedQuartzSystemListener.startup(EmbeddedQuartzSystemListener.java:100)
    at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:364)
    at org.pentaho.platform.engine.core.system.PentahoSystem.access$000(PentahoSystem.java:58)
    at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:301)
    at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:298)
    at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:340)
    at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:298)
    at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:269)
    at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:182)
    at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:136)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)
    at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
    at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)
    at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)
    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)
    at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)
    at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
    at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
    at org.apache.catalina.core.StandardService.start(StandardService.java:525)
    at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
    at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

    Could anyone shows me a way to resolve this problem.

    Thanks in advance
    Paulo Branco

  2. #2
    Join Date
    Oct 2012
    Posts
    6

    Default

    Also have this problem with a PostGreSQL database...

  3. #3
    Join Date
    Nov 2013
    Posts
    19

    Default

    Hi,

    I had the same problem trying to put quartz on a PostgreSQL DB. Reviewing the source code for class EmbeddedQuartzSystemListener, the method 'verifyQuartzIsConfigured' tries to determinate whether your quartz is configured by searching a quartz table.
    But it searches for substring "QRTZ" while the create_quartz_postgresql.sql script gives tables with this pattern : "qrtz*". I figured that the method used is case sensitive so it doesn't return any quartz table.

    ==> Create a fake "QRTZ" table in quartz database solved the problem for me.

    hope that will help !



  4. #4

    Default

    This worked for me! Than you so much for sharing!!!

  5. #5

    Default

    Hi, it works for me too! Thanks.

  6. #6
    Join Date
    Oct 2013
    Posts
    1

    Default

    Thanks nawaa. Works for me

    CREATE TABLE "QRTZ"
    (
    NAME VARCHAR(200) NOT NULL,
    PRIMARY KEY (NAME)
    );

  7. #7
    Join Date
    Dec 2011
    Posts
    4

    Default

    Works with pentaho 5.3 and postgresql too!

  8. #8

    Default

    And with Pentaho 6.1. Thanks.

  9. #9
    Join Date
    Nov 2016
    Posts
    5

    Default

    Works for Version 7 too! Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.