Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
Description
This problem was reported for DB2 database with
(PXEI-547) SimpleScheduler SQLExceptionin JdbcDelegate.updateAssignToNode
17:08:57,622 ERROR [org.apache.ode.scheduler.simple.SimpleScheduler] [OdeScheduler] Database error upgrading jobs.
org.apache.ode.scheduler.simple.DatabaseException: com.ibm.db2.jcc.b.nm: DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610, SQLERRMC=null, DR
IVER=3.50.152
at org.apache.ode.scheduler.simple.JdbcDelegate.updateAssignToNode(JdbcDelegate.java:228)
at org.apache.ode.scheduler.simple.SimpleScheduler$7.call(SimpleScheduler.java:506)
at org.apache.ode.scheduler.simple.SimpleScheduler$7.call(SimpleScheduler.java:502)
at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:208)
at org.apache.ode.scheduler.simple.SimpleScheduler.doUpgrade(SimpleScheduler.java:500)
at org.apache.ode.scheduler.simple.SimpleScheduler$UpgradeJobsTask.run(SimpleScheduler.java:618)
at org.apache.ode.scheduler.simple.SimpleScheduler.runTask(SimpleScheduler.java:442)
at org.apache.ode.scheduler.simple.SchedulerThread.run(SchedulerThread.java:152)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.ibm.db2.jcc.b.nm: DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610, SQLERRMC=null, DRIVER=3.50.152
at com.ibm.db2.jcc.b.wc.a(wc.java:579)
at com.ibm.db2.jcc.b.wc.a(wc.java:57)
at com.ibm.db2.jcc.b.wc.a(wc.java:126)
at com.ibm.db2.jcc.b.tk.c(tk.java:1901)
at com.ibm.db2.jcc.b.tk.d(tk.java:1889)
at com.ibm.db2.jcc.b.tk.a(tk.java:1416)
at com.ibm.db2.jcc.t4.db.g(db.java:138)
at com.ibm.db2.jcc.t4.db.a(db.java:38)
at com.ibm.db2.jcc.t4.t.a(t.java:32)
at com.ibm.db2.jcc.t4.sb.h(sb.java:141)
at com.ibm.db2.jcc.b.tk.N(tk.java:1387)
at com.ibm.db2.jcc.b.uk.Kb(uk.java:2461)
at com.ibm.db2.jcc.b.uk.e(uk.java:3101)
at com.ibm.db2.jcc.b.uk.zb(uk.java:568)
at com.ibm.db2.jcc.b.uk.executeUpdate(uk.java:551)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at org.apache.ode.scheduler.simple.JdbcDelegate.updateAssignToNode(JdbcDelegate.java:226)
... 8 more