Concurrent Program completed noraml but log file showing SQL Exception
Hi
log file displaying exception but program completed normal ,output file is blank.
any body can help how is it possble. Program through below error .
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)
[031808_124042860][][EVENT] Data Generation Completed...
[031808_124042886][][EVENT] Total Data Generation Time 159.69553333333334 minutes
---------------------------------------------------------------------------
Start of log messages from FND_FILE
---------------------------------------------------------------------------
---------------------------------------------------------------------------
End of log messages from FND_FILE
---------------------------------------------------------------------------
---------------------------------------------------------------------------
Executing request completion options...
------------- 1) PUBLISH -------------
Beginning post-processing of request 3392427 on node USMLRH47 at 18-MAR-2008 12:40:43.
Post-processing of request 3392427 completed at 18-MAR-2008 12:40:45.
--------------------------------------
Regards
Ravi