BI Report failing with java.sql.SQLException: ORA-01555: snapshot too old
Hi,XML Report is failing with the following error.
After this error, the report is running for hours and not completing.
Any hints would be highly appreciated.
Calling XDO Data Engine... --SQLException java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number 29 with name "_SYSSMU29_1976628692$" too small at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491) at oracle.apps.xdo.dataengine.XMLPGEN.processQuery(XMLPGEN.java:1947) at oracle.apps.xdo.dataengine.XMLPGEN.processSQLDataSource(XMLPGEN.java:501) at oracle.apps.xdo.dataengine.XMLPGEN.writeData(XMLPGEN.java:445) at oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStructure(XMLPGEN.java:308) at oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:273) at oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:215) at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:254) at oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(DataProcessor.java:390) at oracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:355) at oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:334) at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:294)
0