5 Replies Latest reply on Feb 14, 2013 3:55 PM by 991149

    OSB 11g JCA adapter - "ORA-03111: break received on communication channel"


      While invoking stored procedure from JCA adapter from OSB 11g,Getting error out with this error message "<con:errorCode>BEA-380002</con:errorCode>
      <con:reason>Invoke JCA outbound service failed with connection error, exception: com.bea.wli.sb.transports.jca.JCATransportException: oracle.tip.adapter.sa.api.JCABindingException: oracle.tip.adapter.sa.impl.fw.ext.org.collaxa.thirdparty.apache.wsif.WSIFException: servicebus:/WSDL/cm.cpm_1.0/resources/interfaces/getBalances/getAccountBalance [ getAccountBalance_ptt::getAccountBalance(InputParameters,OutputParameters) ] - WSIF JCA Execute of operation 'getAccountBalance' failed due to: Stored procedure invocation error.
      Error while trying to prepare and execute the SSB_USER.VF_SELFCARE.GETACCOUNTBALANCE API.
      An error occurred while preparing and executing the SSB_USER.VF_SELFCARE.GETACCOUNTBALANCE API. Cause: java.sql.SQLException: ORA-03111: break received on communication channel nested exception is:
      Stored procedure invocation error".This is an intermittent error message.

      Could somebody help in resolving this error.