org.pentaho.platform.api.scheduler2.SchedulerException: Quartz failed to schedule job "RepositoryGcJob"

Pentaho BI Platform Tracking | Elena Neill | 11 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    After enabling GC on the BI server, following steps in this document: http://help.pentaho.com/Documentation/6.0/0P0/100/Jackrabbit_Repository_Performance_Tips, getting the error upon server startup when setting the execute property to now: <property name="execute" value="now"/>. {noformat} ERROR [RepositoryCleanerSystemListener] Scheduler error org.pentaho.platform.api.scheduler2.SchedulerException: Quartz failed to schedule job "RepositoryGcJob" at org.pentaho.platform.scheduler2.quartz.QuartzScheduler.createJob(QuartzScheduler.java:304) at org.pentaho.platform.scheduler2.quartz.QuartzScheduler.createJob(QuartzScheduler.java:182) at org.pentaho.platform.scheduler2.quartz.QuartzScheduler.createJob(QuartzScheduler.java:166) at org.pentaho.platform.plugin.services.repository.RepositoryCleanerSystemListener.scheduleJob(RepositoryCleanerSystemListener.java:156) at org.pentaho.platform.plugin.services.repository.RepositoryCleanerSystemListener.startup(RepositoryCleanerSystemListener.java:122) at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:436) at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:427) at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:406) at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:427) at org.pentaho.platform.engine.core.system.PentahoSystem.access$000(PentahoSystem.java:82) at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:358) at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:355) at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:406) at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:355) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:326) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:222) at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:154) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4729) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5167) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1101) at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1786) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: org.quartz.JobPersistenceException: Couldn't store trigger 'admin RepositoryGcJob 1459780175654' for 'admin RepositoryGcJob 1459780175654' job:ORA-01438: value larger th an specified precision allowed for this column [See nested exception: java.sql.SQLDataException: ORA-01438: value larger than specified precision allowed for this column ] at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1241) at org.quartz.impl.jdbcjobstore.JobStoreSupport$3.execute(JobStoreSupport.java:1043) at org.quartz.impl.jdbcjobstore.JobStoreSupport$40.execute(JobStoreSupport.java:3670) at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3742) at org.quartz.impl.jdbcjobstore.JobStoreTX.executeInLock(JobStoreTX.java:90) at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInLock(JobStoreSupport.java:3666) at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJobAndTrigger(JobStoreSupport.java:1030) at org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.java:743) at org.quartz.impl.StdScheduler.scheduleJob(StdScheduler.java:243) at org.pentaho.platform.scheduler2.quartz.QuartzScheduler.createJob(QuartzScheduler.java:302) ... 29 more Caused by: java.sql.SQLDataException: ORA-01438: value larger than specified precision allowed for this column {noformat}

    Pentaho BI Platform Tracking | 11 months ago | Elena Neill
    org.pentaho.platform.api.scheduler2.SchedulerException: Quartz failed to schedule job "RepositoryGcJob"
  2. 0

    After enabling GC on the BI server, following steps in this document: http://help.pentaho.com/Documentation/6.0/0P0/100/Jackrabbit_Repository_Performance_Tips, getting the error upon server startup when setting the execute property to now: <property name="execute" value="now"/>. {noformat} ERROR [RepositoryCleanerSystemListener] Scheduler error org.pentaho.platform.api.scheduler2.SchedulerException: Quartz failed to schedule job "RepositoryGcJob" at org.pentaho.platform.scheduler2.quartz.QuartzScheduler.createJob(QuartzScheduler.java:304) at org.pentaho.platform.scheduler2.quartz.QuartzScheduler.createJob(QuartzScheduler.java:182) at org.pentaho.platform.scheduler2.quartz.QuartzScheduler.createJob(QuartzScheduler.java:166) at org.pentaho.platform.plugin.services.repository.RepositoryCleanerSystemListener.scheduleJob(RepositoryCleanerSystemListener.java:156) at org.pentaho.platform.plugin.services.repository.RepositoryCleanerSystemListener.startup(RepositoryCleanerSystemListener.java:122) at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:436) at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:427) at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:406) at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:427) at org.pentaho.platform.engine.core.system.PentahoSystem.access$000(PentahoSystem.java:82) at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:358) at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:355) at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:406) at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:355) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:326) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:222) at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:154) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4729) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5167) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1101) at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1786) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: org.quartz.JobPersistenceException: Couldn't store trigger 'admin RepositoryGcJob 1459780175654' for 'admin RepositoryGcJob 1459780175654' job:ORA-01438: value larger th an specified precision allowed for this column [See nested exception: java.sql.SQLDataException: ORA-01438: value larger than specified precision allowed for this column ] at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1241) at org.quartz.impl.jdbcjobstore.JobStoreSupport$3.execute(JobStoreSupport.java:1043) at org.quartz.impl.jdbcjobstore.JobStoreSupport$40.execute(JobStoreSupport.java:3670) at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3742) at org.quartz.impl.jdbcjobstore.JobStoreTX.executeInLock(JobStoreTX.java:90) at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInLock(JobStoreSupport.java:3666) at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJobAndTrigger(JobStoreSupport.java:1030) at org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.java:743) at org.quartz.impl.StdScheduler.scheduleJob(StdScheduler.java:243) at org.pentaho.platform.scheduler2.quartz.QuartzScheduler.createJob(QuartzScheduler.java:302) ... 29 more Caused by: java.sql.SQLDataException: ORA-01438: value larger than specified precision allowed for this column {noformat}

    Pentaho BI Platform Tracking | 11 months ago | Elena Neill
    org.pentaho.platform.api.scheduler2.SchedulerException: Quartz failed to schedule job "RepositoryGcJob"

    Root Cause Analysis

    1. org.pentaho.platform.api.scheduler2.SchedulerException

      Quartz failed to schedule job "RepositoryGcJob"

      at org.pentaho.platform.scheduler2.quartz.QuartzScheduler.createJob()
    2. org.pentaho.platform
      SolutionContextListener.contextInitialized
      1. org.pentaho.platform.scheduler2.quartz.QuartzScheduler.createJob(QuartzScheduler.java:304)
      2. org.pentaho.platform.scheduler2.quartz.QuartzScheduler.createJob(QuartzScheduler.java:182)
      3. org.pentaho.platform.scheduler2.quartz.QuartzScheduler.createJob(QuartzScheduler.java:166)
      4. org.pentaho.platform.plugin.services.repository.RepositoryCleanerSystemListener.scheduleJob(RepositoryCleanerSystemListener.java:156)
      5. org.pentaho.platform.plugin.services.repository.RepositoryCleanerSystemListener.startup(RepositoryCleanerSystemListener.java:122)
      6. org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:436)
      7. org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:427)
      8. org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:406)
      9. org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:427)
      10. org.pentaho.platform.engine.core.system.PentahoSystem.access$000(PentahoSystem.java:82)
      11. org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:358)
      12. org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:355)
      13. org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:406)
      14. org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:355)
      15. org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:326)
      16. org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:222)
      17. org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:154)
      17 frames
    3. Glassfish Core
      HostConfig$DeployDirectory.run
      1. org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4729)
      2. org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5167)
      3. org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
      4. org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
      5. org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
      6. org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
      7. org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1101)
      8. org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1786)
      8 frames
    4. Java RT
      Thread.run
      1. java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
      2. java.util.concurrent.FutureTask.run(FutureTask.java:266)
      3. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      4. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      5. java.lang.Thread.run(Thread.java:745)
      5 frames