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

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by user373569, 1 year ago
ORA-01555: snapshot too old: rollback segment number 136 with name "_SYSSMU136$" too small
via Oracle Community by 807581, 1 year ago
ORA-01490: invalid ANALYZE command
via Oracle Community by 392825, 1 month ago
ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_SESSION", line 90 ORA-06512: at "CLINICAL_T.PKG_MASTER_AUDIT_TRAIL", line 56 ORA-06512: at line 1
via Oracle Community by 617517, 1 year ago
ORA-02292: integrity constraint (CDVUSER.SERVICECONTROL_SERVICEDET_FK1) violated - child record found
via Oracle Community by 570040, 1 year ago
ORA-00907: missing right parenthesis
ava.sql.SQLException: ORA-01555: snapshot too old: rollback segment number 136 with name "_SYSSMU136$" too small
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:589)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1972)
at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:1231)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2607)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2950)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:656)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:582)
at oracle.apps.xdo.dataengine.XMLPGEN.writeData(XMLPGEN.java:456)
at oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStructure(XMLPGEN.java:281)
at oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:251)
at oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:192)
at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:222)
at oracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:334)
at oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:207)
at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:272)
at oracle.apps.fnd.cp.request.Run.main(Run.java:161)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago

Know the solutions? Share your knowledge to help other developers to debug faster.