3 Replies Latest reply on Jul 12, 2017 9:28 PM by John_K

    Concurrent request erroring out with snapshot too old error

    2772429

      [071117_030531220][][STATEMENT] 1:null :

      [071117_030531220][][STATEMENT] 2:null :

      [071117_041633527][][EXCEPTION] SQLException encounter while executing data trigger....

      java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number 7 with name "_SYSSMU7_1314301090$" too small

      ORA-06512: at "APPS.XXHID_INTER_SALES_ORDER_PKG", line 35

      ORA-06512: at line 4

       

      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)

      at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:215)

      at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:965)

      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)

      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)

      at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3445)

      at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4394)

      at oracle.apps.xdo.dataengine.XMLPGEN.executeTriggers(XMLPGEN.java:650)

      at oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:275)

      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)

      at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

       

      Regards,

      Prathap