Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: EmbeddedQuartzSystemListener: ORA-00942: table or view does not exist

  1. #1
    Join Date
    Sep 2011

    Default EmbeddedQuartzSystemListener: ORA-00942: table or view does not exist


    I'm not 100 % sure it is the right forum to ask. My reasoning was that the scheduler has more to do with the platform itself than with just the PDI.

    I got a problem trying to run PDI - EE trial on Oracle as the backend.

    I got a schema with Quartz related tables, yet the org.pentaho.platform.scheduler2.quartz.EmbeddedQuartzSystemListener.verifyQuartzIsConfigured fails with an exception that it can not find the table (was not able to figure out which table it is looking for).

    Has anybody experienced a similar problem?

    What do I miss?


    13:28:37,020 ERROR [EmbeddedQuartzSystemListener] EmbeddedQuartzSystemListener.ERROR_0007_SQLERROR
    java.sql.SQLException: ORA-00942: table or view does not exist

    at oracle.jdbc.driver.DatabaseError.throwSqlException(
    at oracle.jdbc.driver.T4CTTIoer.processError(
    at oracle.jdbc.driver.T4CTTIoer.processError(
    at oracle.jdbc.driver.T4C8Oall.receive(
    at oracle.jdbc.driver.T4CStatement.doOall8(
    at oracle.jdbc.driver.T4CStatement.executeForDescribe(
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(
    at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
    at oracle.jdbc.driver.OracleStatement.executeQuery(
    at org.apache.commons.dbcp.DelegatingStatement.executeQuery(
    at org.pentaho.platform.scheduler2.quartz.EmbeddedQuartzSystemListener.verifyQuartzIsConfigured(
    at org.pentaho.platform.scheduler2.quartz.EmbeddedQuartzSystemListener.startup(
    at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(

  2. #2
    Join Date
    Nov 2005


    AFAIK, PDI-EE server does not support Oracle as a backend. Currently, we are only supporting the out-of-the-box repository and scheduler.

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.