cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Level 1

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

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 4

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

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

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

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.

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

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

Re: wt.pom.DatastoreException: A SQL error has occurred for the statement "UPDATE ScheduleQueue

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?