ORA-01002: fetch out of sequence (Doc ID 1027196.1)

Last updated on NOVEMBER 02, 2016

Applies to:

Sun e*Gate - Version 4.1.2 and later
Oracle Solaris on SPARC (32-bit)
Sun SeeBeyond e*Gate - Version: 4.5.1 and later
Oracle Solaris SPARC (32-bit)

Symptoms

This error can occur when using the Oracle Java e*Way.

Diagnostics:

14:10:38.243 CDB I 14 (initialize.cxx:863): PreparedStatementAgent.sessionOpen(): (Re)prepared SQL -> select peterw from foo
14:10:38.455 CDB W 14 (initialize.cxx:863): Session.checkConnection(): Check connection status

14:10:38.456 CDB W 14 (initialize.cxx:863): Session.checkConnection(): Oracle Error code: 1002

14:10:38.461 CDB W 14 (initialize.cxx:863): Session.checkConnection(): Connection is UP

14:10:38.461 COLV I 14 (initialize.cxx:863): ORA-01002: fetch out of sequence
14:10:38.473 COL I 14 (initialize.cxx:1393): JCS: Java collaboration translate() method threw a com.stc.common.collabService.CollabConnException!

14:10:38.474 COL I 14 (initialize.cxx:863): *************** Exception occurred **************

14:10:38.476 COL I 14 (initialize.cxx:863): toString: com.stc.common.collabService.CollabConnException: JCCollabControllerImpl (translate) Error in executing translate method
com.stc.common.collabService.CollabConnException: JCCollabControllerImpl (translate) Error on calling translate method of USER CLASS class crPeterw
com.stc.common.collabService.CollabDataException: JCollaboration.translate(): Caught unspecified exception from user collaboration executeBusinessRules()
java.lang.NullPointerException
at crPeterw.executeBusinessRules(crPeterw.java:103)
at com.stc.jcsre.JCollaboration.translate(JCollaboration.java:133)
at com.stc.common.collabService.JCCollabControllerImpl.translate(JCCollabControllerImpl.java:1247)
at com.stc.jcsre.JCollaboration.translate(JCollaboration.java:150)
at com.stc.common.collabService.JCCollabControllerImpl.translate(JCCollabControllerImpl.java:1247)
at com.stc.common.collabService.JCCollabControllerImpl.translate(JCCollabControllerImpl.java:1282)
14:10:38.477 COL I 14 (initialize.cxx:863):

14:10:38.477 COL I 14 (initialize.cxx:863): getMessage: JCCollabControllerImpl (translate) Error in executing translate method

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