0 Replies Latest reply on Oct 10, 2019 1:57 PM by 3670334

    Large paylod oracle b2b

    3670334
    3670334 Oct 10, 2019 1:57 PM

      Hello,

       

       

      APPLIES TO:

      Oracle SOA Suite - Version 12.2.1.3.0

       

      Customer is having issue in processing payloads over 12 Mb.

       

       

      Flow is : Trading Partner sends a document over AS2  and B2B receives the payload and sends it to a custom AQ queue.

      SOA Composite picks and process the payload from custom AQ queue.

       

       

      Whenever a payload over 10 Mb is received with large payload size set to 2Mb, following exception occurs in JDBC layer.

       

       

      There are no wire or business messages created.

       

      ----

      Internal Exception: java.sql.SQLRecoverableException: IO Error: Broken pipe

      Error Code: 17002

      Call: SELECT CLOB_VALUE FROM B2B_DATA_STORAGE WHERE (ID = ?) FOR UPDATE

              bind => [1 parameter bound]

      Query: InsertObjectQuery(oracle.tip.b2b.model.instance.DataStorage@5cae52f9)>

      <Oct 10, 2019 12:16:27,875 PM WEST> <Warning> <JDBC> <BEA-001594> <Forcibly releasing an already closed connection "[weblogic.jdbc.wrapper.JTAConnection_weblogic_jdbc_wrapper_XAConnection_oracle_jdbc_driver_LogicalConnection-SOADataSource-1428166, null]" back into the data source connection pool "null".>

      <Oct 10, 2019 12:16:28,882 PM WEST> <Error> <oracle.soa.b2b.engine> <BEA-000000> <weblogic.transaction.RollbackException: Unexpected exception in beforeCompletion: sync=org.eclipse.persistence.transaction.JTASynchronizationListener@53a4faa5