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

Oracle Community | user373569 | 9 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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