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)
