Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Oracle Repository

  1. #1

    Default Oracle Repository

    I am following the article in the wiki

    http://wiki.pentaho.org/display/Pent...for+Oracle+10g

    During startup I am able to see some tables being created but when I it gets to quartz I got errors. The first was no solution-repository/db-repository-name so I added that into my pentaho.xml (this should be added to the page above) Details on adding this our here

    http://wiki.pentaho.org/display/Pent...epository+Node

    Now I am getting this

    Code:
    10:10:50,241 INFO  [HibernateUtil] Hibernate being used in un-managed environment - using static for factory.
    10:10:57,882 WARN  [JCommon] Failed to create factory cache: com/opensymphony/oscache/general/GeneralCacheAdministrator
    10:10:59,632 INFO  [SolutionRepositoryBase] Using solution name: null
    10:11:02,085 ERROR [STDERR] org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't clean volatile data: ORA-00942: table or view does not exist
     [See nested exception: java.sql.SQLException: ORA-00942: table or view does not exist
    ]]
    Seems like the quartz tables are never created. Does anybody have any ideas?

  2. #2

    Default Sorry!

    The instructions clearly say to generate the quartz tables see quartz. The scripts are in the downloaded zip.

    Its working now! On to the deployment build.

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.