ava.lang.Exception: oracle.sysman.emSDK.webservices.wsdlapi.SoapTestException: Client received SOAP Fault from server : Exception occured when binding was invoked. Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'CreditCardDBServiceSelect' failed due to: DBReadInteractionSpec Execute Failed Exception. Query name: [CreditCardDBServiceSelect], Descriptor name: [CreditCardDBService.Creditcards]. Caused by java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist . See root exception for the specific exception. This exception is considered retriable, likely due to a communication failure. To classify it as non-retriable instead add property nonRetriableErrorCodes with value "942" to your deployment descriptor (i.e. weblogic-ra.xml). To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff. All properties are integers. ". The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution.

Oracle Community | G Vijay | 2 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Error While executing the SOA Composite application.

    Oracle Community | 2 years ago | G Vijay
    ava.lang.Exception: oracle.sysman.emSDK.webservices.wsdlapi.SoapTestException: Client received SOAP Fault from server : Exception occured when binding was invoked. Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'CreditCardDBServiceSelect' failed due to: DBReadInteractionSpec Execute Failed Exception. Query name: [CreditCardDBServiceSelect], Descriptor name: [CreditCardDBService.Creditcards]. Caused by java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist . See root exception for the specific exception. This exception is considered retriable, likely due to a communication failure. To classify it as non-retriable instead add property nonRetriableErrorCodes with value "942" to your deployment descriptor (i.e. weblogic-ra.xml). To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff. All properties are integers. ". The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution.
  2. 0

    oracle.sysman.emSDK.webservices.wsdlapi.SoapTestException: null

    Oracle Community | 7 years ago | 747798
    ava.lang.Exception: oracle.sysman.emSDK.webservices.wsdlapi.SoapTestException: null
  3. 0

    Error while Invoking Web Service: Fusion Payables( CreateInvoiceInterface)

    Oracle Community | 4 years ago | RakeshR
    oracle.sysman.emSDK.webservices.wsdlapi.SoapTestException: Client received SOAP Fault from server : MOAC Priv Name cannot be null; Initialize MOAC
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Java Embedding Activity in BPEL

    Oracle Community | 3 years ago | Mohanraj Nataraj
    java.lang.Exception: oracle.sysman.emSDK.webservices.wsdlapi.SoapTestException: Client received SOAP Fault from server : Correlation definition not registered. The correlation set definition for operation execute, process default/Project1!1.0*soa_fdf8d269-7a8b-4d8c-9db9-f0901bc88a8a /BPELProcess1, is not registered with the server . The correlation set was not defined in the process . Redeploy the process to the container.
  6. 0

    DBReadInteractionSpec Execute Failed Exception.

    Oracle Community | 5 years ago | 937431
    java.lang.Exception: oracle.sysman.emSDK.webservices.wsdlapi.SoapTestException: Client received SOAP Fault from server : Exception occured when binding was invoked. Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'getCreditValidationSelect' failed due to: DBReadInteractionSpec Execute Failed Exception. Query name: [getCreditValidationSelect], Descriptor name: [getCreditValidation.Creditcardinfo]. Caused by Exception [EclipseLink-6003] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.QueryException Exception Description: The number of arguments provided to the query for execution does not match the number of arguments in the query definition. Query: ReadAllQuery(name="getCreditValidationSelect" referenceClass=Creditcardinfo sql="SELECT CCNUMBER, STATUS FROM CREDITCARDINFO WHERE (CCNUMBER = ?)"). See root exception for the specific exception. This exception is considered not retriable, likely due to a modelling mistake. ". The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution.

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. oracle.sysman.emSDK.webservices.wsdlapi.SoapTestException

      Client received SOAP Fault from server : Exception occured when binding was invoked. Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'CreditCardDBServiceSelect' failed due to: DBReadInteractionSpec Execute Failed Exception. Query name: [CreditCardDBServiceSelect], Descriptor name: [CreditCardDBService.Creditcards]. Caused by java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist . See root exception for the specific exception. This exception is considered retriable, likely due to a communication failure. To classify it as non-retriable instead add property nonRetriableErrorCodes with value "942" to your deployment descriptor (i.e. weblogic-ra.xml). To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff. All properties are integers. ". The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution.

      at oracle.sysman.emSDK.webservices.wsdlapi.dispatch.DispatchUtil.invoke()
    2. oracle.sysman.emSDK
      OperationInfoImpl.invokeWithDispatch
      1. oracle.sysman.emSDK.webservices.wsdlapi.dispatch.DispatchUtil.invoke(DispatchUtil.java:362)
      2. oracle.sysman.emSDK.webservices.wsdlparser.OperationInfoImpl.invokeWithDispatch(OperationInfoImpl.java:1004)
      2 frames
    3. oracle.sysman.emas
      WSTestModel.invokeOperation
      1. oracle.sysman.emas.model.wsmgt.PortName.invokeOperation(PortName.java:750)
      2. oracle.sysman.emas.model.wsmgt.WSTestModel.invokeOperation(WSTestModel.java:808)
      2 frames