1 Reply Latest reply on May 19, 2015 2:58 PM by Cdelahun-Oracle

    toplink Exception 4002

    1551405

      Hi All,

       

      I am getting below exception while running bursting from BI Publisher. This error is not coming on regular but its keep on hitting and some time it will resolve after restarting the server but again it come back, Please help me to solve this issue.

       

       

      Exception [TOPLINK-4002] (Oracle TopLink -10g Release 3 (10.1.3.0.0) (Build 060118)): oracle.toplink.exceptions.DatabaseException Internal Exception: java.sql.SQLException: Io exception: Connection resetError Code: 17002 Call:UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + 1 WHERE SEQ_NAME = 'SUBSCRIPTION_ID_SEQ' Query:DataModifyQuery()

      Error Detail

       

       

      oracle.apps.xdo.servlet.scheduler.ProcessingException: Exception [TOPLINK-4002] (Oracle TopLink - 10g Release 3 (10.1.3.0.0) (Build 060118)): oracle.toplink.exceptions.DatabaseException

      Internal Exception: java.sql.SQLException: Io exception: Connection resetError Code: 17002

      Call:UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + 1 WHERE SEQ_NAME = 'SUBSCRIPTION_ID_SEQ'

      Query:DataModifyQuery()

              at oracle.apps.xdo.servlet.scheduler.toplink.ToplinkDataHandler.insertJob(ToplinkDataHandler.java:604)

              at oracle.apps.xdo.servlet.ui.scheduler.SchedulerServlet.scheduleJob(SchedulerServlet.java:1852)

              at oracle.apps.xdo.servlet.ui.scheduler.SchedulerServlet.doPost(SchedulerServlet.java:289)

              at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)

              at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

              at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)

              at oracle.apps.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:80)

              at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)

              at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:368)

              at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:866)

              at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:448)

              at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:216)

              at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:117)

              at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:110)

              at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)

              at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)

              at java.lang.Thread.run(Thread.java:595)

      Caused by: Exception [TOPLINK-4002] (Oracle TopLink - 10g Release 3 (10.1.3.0.0) (Build 060118)): oracle.toplink.exceptions.DatabaseException

      Internal Exception: java.sql.SQLException: Io exception: Connection resetError Code: 17002

      Call:UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + 1 WHERE SEQ_NAME = 'SUBSCRIPTION_ID_SEQ'

      Query:DataModifyQuery()

              at oracle.toplink.exceptions.DatabaseException.sqlException(DatabaseException.java:282)

              at oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:658)

              at oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:707)

              at oracle.toplink.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:496)

              at oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:442)

              at oracle.toplink.publicinterface.Session.executeCall(Session.java:717)

              at oracle.toplink.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:117)

              at oracle.toplink.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:103)

              at oracle.toplink.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:146)

              at oracle.toplink.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:126)

              at oracle.toplink.queryframework.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:54)

              at oracle.toplink.queryframework.DatabaseQuery.execute(DatabaseQuery.java:603)

              at oracle.toplink.publicinterface.Session.internalExecuteQuery(Session.java:2062)

              at oracle.toplink.publicinterface.Session.executeQuery(Session.java:981)

              at oracle.toplink.publicinterface.Session.executeQuery(Session.java:953)

              at oracle.toplink.sequencing.QuerySequence.update(QuerySequence.java:289)

              at oracle.toplink.sequencing.QuerySequence.updateAndSelectSequence(QuerySequence.java:238)

              at oracle.toplink.sequencing.StandardSequence.getGeneratedVector(StandardSequence.java:58)

              at oracle.toplink.sequencing.DefaultSequence.getGeneratedVector(DefaultSequence.java:121)

              at oracle.toplink.sequencing.Sequence.getGeneratedVector(Sequence.java:229)

              at oracle.toplink.internal.sequencing.SequencingManager$Preallocation_Transaction_NoAccessor_State.getNextValue(SequencingManager.java:382)

              at oracle.toplink.internal.sequencing.SequencingManager.getNextValue(SequencingManager.java:864)

              at oracle.toplink.internal.sequencing.ClientSessionSequencing.getNextValue(ClientSessionSequencing.java:75)

              at oracle.toplink.internal.descriptors.ObjectBuilder.assignSequenceNumber(ObjectBuilder.java:201)

              at oracle.toplink.publicinterface.UnitOfWork.assignSequenceNumbers(UnitOfWork.java:376)

              at oracle.toplink.publicinterface.UnitOfWork.collectAndPrepareObjectsForCommit(UnitOfWork.java:774)

              at oracle.toplink.publicinterface.UnitOfWork.commitToDatabaseWithChangeSet(UnitOfWork.java:1312)

              at oracle.toplink.publicinterface.UnitOfWork.commitRootUnitOfWork(UnitOfWork.java:1097)

              at oracle.toplink.publicinterface.UnitOfWork.commit(UnitOfWork.java:865)

              at oracle.apps.xdo.servlet.scheduler.toplink.ToplinkDataHandler.insertJob(ToplinkDataHandler.java:592)

              ... 16 more

      Caused by: java.sql.SQLException: Io exception: Connection reset

              at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)

              at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:175)

              at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:287)

              at oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:577)

              at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1161)

              at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1585)

              at oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:649)

              ... 44 more

       

      Thanks in advances