java.sql.SQLDataException: ORA-01438: value larger than specified precision allowed for this column ]

Pentaho BI Platform Tracking | Elena Neill | 12 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded 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 | 12 months ago | Elena Neill
    java.sql.SQLDataException: ORA-01438: value larger than specified precision allowed for this column ]
  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 | 12 months ago | Elena Neill
    java.sql.SQLDataException: ORA-01438: value larger than specified precision allowed for this column ]

    Root Cause Analysis

    1. java.sql.SQLDataException

      ORA-01438: value larger than specified precision allowed for this column ]

      at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger()
    2. quartz
      StdScheduler.scheduleJob
      1. org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1241)
      2. org.quartz.impl.jdbcjobstore.JobStoreSupport$3.execute(JobStoreSupport.java:1043)
      3. org.quartz.impl.jdbcjobstore.JobStoreSupport$40.execute(JobStoreSupport.java:3670)
      4. org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3742)
      5. org.quartz.impl.jdbcjobstore.JobStoreTX.executeInLock(JobStoreTX.java:90)
      6. org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInLock(JobStoreSupport.java:3666)
      7. org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJobAndTrigger(JobStoreSupport.java:1030)
      8. org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.java:743)
      9. org.quartz.impl.StdScheduler.scheduleJob(StdScheduler.java:243)
      9 frames
    3. org.pentaho.platform
      QuartzScheduler.createJob
      1. org.pentaho.platform.scheduler2.quartz.QuartzScheduler.createJob(QuartzScheduler.java:302)
      1 frame