ava.sql.SQLException: ORA-01555: snapshot too old: rollback segment number 136 with name "_SYSSMU136$" too small

Oracle Community | user373569 | 9 years ago
  1. 0

    Concurrent Program completed noraml but log file showing SQL Exception

    Oracle Community | 9 years ago | user373569
    ava.sql.SQLException: ORA-01555: snapshot too old: rollback segment number 136 with name "_SYSSMU136$" too small
  2. 0

    OAException: oracle.jbo.DMLException: JBO-26041: Failed to post data

    Oracle Community | 8 years ago | 617517
    ava.sql.SQLException: ORA-02292: integrity constraint (CDVUSER.SERVICECONTROL_SERVICEDET_FK1) violated - child record found
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    repcreate

    Oracle Community | 10 years ago | 570040
    ava.sql.SQLException: ORA-00907: missing right parenthesis
  5. 0

    java.sql.SQLException: Logical handle no longer valid at

    Oracle Community | 1 decade ago | 384105
    ava.sql.SQLException: Logical handle no longer valid

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. ava.sql.SQLException

      ORA-01555: snapshot too old: rollback segment number 136 with name "_SYSSMU136$" too small

      at oracle.jdbc.dbaccess.DBError.throwSqlException()
    2. oracle.jdbc.dbaccess
      DBError.throwSqlException
      1. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
      1 frame
    3. oracle.jdbc.ttc7
      TTC7Protocol.fetch
      1. oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
      2. oracle.jdbc.ttc7.Oall7.receive(Oall7.java:589)
      3. oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1972)
      4. oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:1231)
      4 frames
    4. Oracle jdbc
      OraclePreparedStatement.executeQuery
      1. oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2607)
      2. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2950)
      3. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:656)
      4. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:582)
      4 frames
    5. oracle.apps.xdo
      JCP4XDODataEngine.runProgram
      1. oracle.apps.xdo.dataengine.XMLPGEN.writeData(XMLPGEN.java:456)
      2. oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStructure(XMLPGEN.java:281)
      3. oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:251)
      4. oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:192)
      5. oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:222)
      6. oracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:334)
      7. oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:207)
      8. oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:272)
      8 frames
    6. oracle.apps.fnd
      Run.main
      1. oracle.apps.fnd.cp.request.Run.main(Run.java:161)
      1 frame