ORA-01002 error when recovering ToDoItems. (Doc ID 1129083.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Business Process Management Suite - Version 10.3.1 and later
Information in this document applies to any platform.
***Checked for relevance on 3-Apr-2012***


Symptoms

The following error occurs in production engine logs when recovering past due to do items.

An exception occurred while executing a transaction. Details:
An error occurred while accesing the database.
Detail:SQL statement: 'unknown'

Caused by: [BEA][Oracle JDBC Driver][Oracle]ORA-01002: fetch out of sequence

fuego.transaction.DatabaseException: An error occurred while accesing the database.
Detail:SQL statement: 'unknown'

at fuego.server.persistence.jdbc.JdbcToDoItemPersMgr.createItem(JdbcToDoItemPersMgr.java:734)
at fuego.server.persistence.ToDoItemIterator.next(ToDoItemIterator.java:75)
at fuego.ejbengine.EJBToDoQueue$RecoverLostItem.doTheJob(EJBToDoQueue.java:802)
at fuego.ejbengine.EJBToDoQueue.sendToDoItems(EJBToDoQueue.java:681)
at fuego.ejbengine.EJBToDoQueue.access$400(EJBToDoQueue.java:65)
at fuego.ejbengine.EJBToDoQueue$RecoverLostItem.execute(EJBToDoQueue.java:785)
at fuego.server.execution.DefaultEngineExecution$AtomicExecutionTA.runTransaction(DefaultEngineExecution.java:304)
at fuego.transaction.TransactionAction.startBaseTransaction(TransactionAction.java:470)
at fuego.transaction.TransactionAction.startTransaction(TransactionAction.java:551)
at fuego.transaction.TransactionAction.start(TransactionAction.java:212)
at fuego.server.execution.DefaultEngineExecution.executeImmediate(DefaultEngineExecution.java:123)
at fuego.server.execution.DefaultEngineExecution.executeAutomaticWork(DefaultEngineExecution.java:62)
at fuego.server.execution.EngineExecution.executeAutomaticWork(EngineExecution.java:42)
at fuego.ejbengine.EJBToDoQueue.executeItem(EJBToDoQueue.java:299)
at fuego.ejbengine.EJBToDoQueue.recoverItems(EJBToDoQueue.java:377)
at fuego.ejbengine.EJBToDoQueue.recoverLostItems(EJBToDoQueue.java:223)
at fuego.ejbengine.cluster.DistributedEJBToDoQueue.recoverLostItems(DistributedEJBToDoQueue.java:82)
at fuego.ejbengine.ejb.EngineStartupBean.recoverLostItems(EngineStartupBean.java:146)
at fuego.ejbengine.ejb.EngineStartupBean_118jex_ELOImpl.recoverLostItems(EngineStartupBean_118jex_ELOImpl.java:140)
at fuego.ejbengine.servlet.SchedulerServlet$RecoverLostItemsTask.runImpl(SchedulerServlet.java:56)
at fuego.ejbengine.servlet.AbstractSchedulerServlet$ScheduledTask.run(AbstractSchedulerServlet.java:199)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)
Caused by: java.sql.SQLException: [BEA][Oracle JDBC Driver][Oracle]ORA-01002: fetch out of sequence

at weblogic.jdbc.base.BaseExceptions.createException(Unknown Source)
at weblogic.jdbc.base.BaseExceptions.getException(Unknown Source)
at weblogic.jdbc.oracle.OracleImplStatement.fetchNext(Unknown Source)
at weblogic.jdbc.oracle.OracleImplStatement.fetchNext2(Unknown Source)
at weblogic.jdbc.oracle.OracleImplResultset.fetchAtPosition(Unknown Source)
at weblogic.jdbc.base.BaseImplResultSet.next(Unknown Source)
at weblogic.jdbc.base.BaseResultSet.next(Unknown Source)
at weblogic.jdbcx.base.BaseResultSetWrapper.next(Unknown Source)
at weblogic.jdbc.wrapper.ResultSet_weblogic_jdbcx_base_BaseResultSetWrapper.next(Unknown Source)
at fuego.jdbc.FaultTolerantResultSet.next(FaultTolerantResultSet.java:553)
at fuego.server.persistence.jdbc.JdbcToDoItemPersMgr.createItem(JdbcToDoItemPersMgr.java:712)
... 22 more

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms