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

Pentaho BI Platform Tracking | Elena Neill | 1 year ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  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 | 1 year 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 | 1 year 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