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

Pentaho BI Platform Tracking | Elena Neill | 1 year 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 | 1 year 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 | 1 year 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