org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't recover jobs: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=SCHED_NAME, DRIVER=3.63.75 [See nested exception: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=SCHED_NAME, DRIVER=3.63.75]]

Terracotta | dolorx | 5 years 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

    DB2 9.7 (driverDelegateClass)

    Terracotta | 5 years ago | dolorx
    org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't recover jobs: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=SCHED_NAME, DRIVER=3.63.75 [See nested exception: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=SCHED_NAME, DRIVER=3.63.75]]

    Root Cause Analysis

    1. com.ibm.db2.jcc.am.SqlSyntaxErrorException

      DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=SCHED_NAME, DRIVER=3.63.75

      at com.ibm.db2.jcc.am.fd.a()
    2. IBM DB2
      zn.executeUpdate
      1. com.ibm.db2.jcc.am.fd.a(fd.java:679)
      2. com.ibm.db2.jcc.am.fd.a(fd.java:60)
      3. com.ibm.db2.jcc.am.fd.a(fd.java:127)
      4. com.ibm.db2.jcc.am.yn.c(yn.java:2644)
      5. com.ibm.db2.jcc.am.yn.d(yn.java:2632)
      6. com.ibm.db2.jcc.am.yn.a(yn.java:2097)
      7. com.ibm.db2.jcc.am.zn.a(zn.java:7197)
      8. com.ibm.db2.jcc.t4.cb.h(cb.java:141)
      9. com.ibm.db2.jcc.t4.cb.b(cb.java:41)
      10. com.ibm.db2.jcc.t4.q.a(q.java:32)
      11. com.ibm.db2.jcc.t4.sb.i(sb.java:135)
      12. com.ibm.db2.jcc.am.yn.gb(yn.java:2066)
      13. com.ibm.db2.jcc.am.zn.pc(zn.java:3446)
      14. com.ibm.db2.jcc.am.zn.b(zn.java:4236)
      15. com.ibm.db2.jcc.am.zn.dc(zn.java:757)
      16. com.ibm.db2.jcc.am.zn.executeUpdate(zn.java:740)
      16 frames
    3. c3p0:JDBC DataSources/Resource Pools
      NewProxyPreparedStatement.executeUpdate
      1. com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
      1 frame
    4. quartz
      JobStoreSupport.recoverJobs
      1. org.quartz.impl.jdbcjobstore.StdJDBCDelegate.updateTriggerStatesFromOtherStates(StdJDBCDelegate.java:259)
      2. org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:844)
      2 frames