0 Replies Latest reply: Jul 19, 2013 10:29 AM by 1026555 RSS

    Format Payment Instructions ends in error after upgrade DB 11gR1 to 11gR2

    1026555

      Hi,

       

      We have been experiencing an issue after upgrade the DB from release 11.0.1.0.7 to 11.2.0.3.

       

      The concurrents: Payment Instruction Register & Format Payment Instructions; are ending in error. The concurrents have the same error, the log shows something like that:

       

      After extract call args, before create extract.  Timestamp: Thu Jul 18 19:12:12 EDT 2013

      End.  Timestamp: Thu Jul 18 19:12:12 EDT 2013

      End doExtractAndFormatCore Timestamp: Thu Jul 18 19:12:12 EDT 2013

      No extract has been previously created. Create extract.Timestamp: Thu Jul 18 19:12:12 EDT 2013

      java.sql.SQLRecoverableException: No more data to read from socket

          at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1200)

          at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155)

          at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:279)

          at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)

          at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)

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

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

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

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

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

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

          at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)

          at oracle.apps.iby.engine.ExtractGenerator.createExtract(ExtractGenerator.java:85)

          at oracle.apps.iby.scheduler.FDFormatProgramUtils.doExtractAndFormatCore(FDFormatProgramUtils.java:258)

          at oracle.apps.iby.scheduler.FDFormatProgramUtils.doExtractAndFormatCommon(FDFormatProgramUtils.java:234)

          at oracle.apps.iby.scheduler.FDFormatProgramUtils.doPmtInstrExtractAndFormat(FDFormatProgramUtils.java:90)

          at oracle.apps.iby.scheduler.FDExtractAndFormatting.doExtractAndFormat(FDExtractAndFormatting.java:456)

          at oracle.apps.iby.scheduler.FDExtractAndFormatting.runMainLogic(FDExtractAndFormatting.java:278)

          at oracle.apps.iby.scheduler.FDExtractAndFormatting.runProgram(FDExtractAndFormatting.java:159)

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

       

      oracle.apps.iby.exception.DatabaseException: SQLException occurred: No more data to read from socket

       

          at oracle.apps.iby.database.DBWrapper.raiseDBException(DBWrapper.java:208)

          at oracle.apps.iby.database.DBWrapper.raiseDBException(DBWrapper.java:218)

          at oracle.apps.iby.engine.ExtractGenerator.createExtract(ExtractGenerator.java:89)

          at oracle.apps.iby.scheduler.FDFormatProgramUtils.doExtractAndFormatCore(FDFormatProgramUtils.java:258)

          at oracle.apps.iby.scheduler.FDFormatProgramUtils.doExtractAndFormatCommon(FDFormatProgramUtils.java:234)

          at oracle.apps.iby.scheduler.FDFormatProgramUtils.doPmtInstrExtractAndFormat(FDFormatProgramUtils.java:90)

          at oracle.apps.iby.scheduler.FDExtractAndFormatting.doExtractAndFormat(FDExtractAndFormatting.java:456)

          at oracle.apps.iby.scheduler.FDExtractAndFormatting.runMainLogic(FDExtractAndFormatting.java:278)

          at oracle.apps.iby.scheduler.FDExtractAndFormatting.runProgram(FDExtractAndFormatting.java:159)

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

       

      SQLException occurred: No more data to read from socket

       

      An error occurred. Roll back any changes.

      Error while doing Rollback

       

      We have opened an SR, but this is taking a long time to resolve this issue, we have applied some recommended patches but not fix the issue. This issue has a high impact in the company, the same issue is present on the production and test instances

       

      We hope that you can help us.

       

      Regards,

       

      Daniel