Skip to main content
K
KanifG1-Visitor
1-Visitor
November 17, 2012
Question

wt.pom.DatastoreException: A SQL error has occurred for the statement "UPDATE ScheduleQueueEntry SET

  • November 17, 2012
  • 4 replies
  • 4630 views

I am getting this error frequently, Method Server goes into loop and never come back after heavy logs size.

Error is:

commonScheduleQueue.SchedulingThread: ERROR : wt.queue.ScheduleQueue.commonScheduleQueue -

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: (wt.pom.pomResource/0) wt.pom.PersistenceException: A persistence error occurred. System message follows:

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: Nested exception is: wt.pom.DatastoreException: A SQL error has occurred for the statement "UPDATE ScheduleQueueEntry SET args=?,classnamekeydomainRef=?,idA3domainRef=?,endExec=?,entryNumber=?,entryOwnerIsNull=?,classnamekeyB5=?,idA3B5=?,failureCount=?,inheritedDomain=?,datelock=?,classnamekeyA2lock=?,idA3A2lock=?,notelock=?,classnamekeyA6=?,idA3A6=?,classnamekeyA5=?,idA3A5=?,scheduleTime=?,securityLabels=?,startExec=?,statusInfoIsNull=?,codeC5=?,messageC5=?,rescheduleTimeC5=?,targetClass=?,targetMethod=?,markForDeleteA2=?,updateStampA2=?,modifyStampA2=?,updateCountA2=updateCountA2+1 WHERE ((idA2A2 = ?) AND (updateCountA2 = ?))". Database system message follows:

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: Nested exception is: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread:

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1010)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3657)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at wt.pds.SQLDatabasePds.updateList(SQLDatabasePds.java:2426)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at wt.pds.SQLDatabasePds.update(SQLDatabasePds.java:299)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at wt.pom.PersistentObjectManager.update(PersistentObjectManager.java:2638)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at wt.pom.PersistentObjectManager.update(PersistentObjectManager.java:822)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at wt.fc.StandardPersistenceManager.update(StandardPersistenceManager.java:1356)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at wt.fc.StandardPersistenceManager.update(StandardPersistenceManager.java:1337)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at wt.queue.ScheduleQueueEntry.update(ScheduleQueueEntry.java:449)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at wt.queue.ScheduleQueue.execEntry(ScheduleQueue.java:346)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at wt.queue.ScheduleQueue.execEntries(ScheduleQueue.java:412)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at wt.queue.ScheduleQueueThread.processReadyEntries(ScheduleQueueThread.java:257)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at wt.queue.ScheduleQueueThread.run(ScheduleQueueThread.java:75)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: ERROR : wt.queue.ScheduleQueue.commonScheduleQueue wcadmin -

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: (wt.pom.pomResource/0) wt.pom.PersistenceException: A persistence error occurred. System message follows:

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: Nested exception is: wt.pom.DatastoreException: A SQL error has occurred for the statement "UPDATE ScheduleQueueEntry SET args=?,classnamekeydomainRef=?,idA3domainRef=?,endExec=?,entryNumber=?,entryOwnerIsNull=?,classnamekeyB5=?,idA3B5=?,failureCount=?,inheritedDomain=?,datelock=?,classnamekeyA2lock=?,idA3A2lock=?,notelock=?,classnamekeyA6=?,idA3A6=?,classnamekeyA5=?,idA3A5=?,scheduleTime=?,securityLabels=?,startExec=?,statusInfoIsNull=?,codeC5=?,messageC5=?,rescheduleTimeC5=?,targetClass=?,targetMethod=?,markForDeleteA2=?,updateStampA2=?,modifyStampA2=?,updateCountA2=updateCountA2+1 WHERE ((idA2A2 = ?) AND (updateCountA2 = ?))". Database system message follows:

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: Nested exception is: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread:

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1010)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3657)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at wt.pds.SQLDatabasePds.updateList(SQLDatabasePds.java:2426)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at wt.pds.SQLDatabasePds.update(SQLDatabasePds.java:299)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at wt.pom.PersistentObjectManager.update(PersistentObjectManager.java:2638)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at wt.pom.PersistentObjectManager.update(PersistentObjectManager.java:822)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at wt.fc.StandardPersistenceManager.update(StandardPersistenceManager.java:1356)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at wt.fc.StandardPersistenceManager.update(StandardPersistenceManager.java:1337)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at wt.queue.ScheduleQueueEntry.update(ScheduleQueueEntry.java:449)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at wt.queue.ScheduleQueue.execEntry(ScheduleQueue.java:311)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at wt.queue.ScheduleQueue.execEntries(ScheduleQueue.java:412)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at wt.queue.ScheduleQueueThread.processReadyEntries(ScheduleQueueThread.java:257)

Sat 11/17/12 15:34:45: commonScheduleQueue.SchedulingThread: at wt.queue.ScheduleQueueThread.run(ScheduleQueueThread.java:75)

4 replies

J
jessh12-Amethyst
12-Amethyst
November 17, 2012

I'd ask technical support, but my recollection is that this is an indication of an Oracle bug fixed in an Oracle patch.

M
MorganBelais11-Garnet
11-Garnet
November 19, 2012

We got this BUG few months ago.

The bug is that if you have the same table in multiple schema, sometime Oracle get lost. We got a patch from Oracle support.

You should be able to find the bug easily on mysupport.

K
KanifG1-VisitorAuthor
1-Visitor
December 5, 2012

Thanks a lot, seems like i need to install the Oracle patch to fix this..

G
ganesh_k1-Visitor
1-Visitor
June 20, 2018

Hello,

 

I am also facing the same issue(I am using Oracle 11.2.0). 

Can anyone of you tell me the patch version that will fix this issue?

Terms & ConditionsAccessibility statement