Invoking JCA Adapter Crashes
(Doc ID 2366965.1)
Last updated on MARCH 28, 2023
Applies to:
Oracle Service Bus - Version 12.2.1.3.0 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.1.3.0 version, OSB Core Functionality
Invoking JCA adapter Crashes
When Invoking JCA adapter from pipeline it crashes, but when calling the Business Service Directly it is working fine.
ERROR
-----------------------
OSB-380001,BINDING.JCA-11633
Invoke JCA outbound service failed with application 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:/bus.svc/PowerCard/CardActivity/wsdl/bus_svc_PowerCard_CardActivityTable_getData.wsdl [ bus_svc_PowerCard_CardActivityTable_getData_ptt::bus.svc.PowerCard.CardActivityTable.getData(bus.svc.PowerCard.CardActivityTable.getDataInput_msg,bus.svc.PowerCard.CardActivityTable.getDataOutputCollection) ] - WSIF JCA Execute of operation 'bus.svc.PowerCard.CardActivityTable.getData' failed due to: Pure SQL Exception.
Pure SQL Execute of select CHANNEL, SERVICE_TYPE, SERVICE_REFERENCE, IDENTIFIER_ID, IDENTIFIER_TYPE, CR_ACCOUNT_NBR, TRANSACTION_REF_NUM, to_char(STATEMENT_DATE,'yyyy-mm-dd hh:mm:ss') , to_char(TRANSACTION_DATE,'yyyy-mm-dd hh:mm:ss'), TRANSACTION_TYPE, DEBIT_CREDIT_FLAG, BILLING_AMOUNT, BILLING_CURRENCY, MERCHANT_NAME, MERCHANT_CITY, TRANSACTION_AMOUNT, TRANSACTION_CURRENCY, TRANSACTION_DESC, TRANSACTION_STATUS, INSTALLMENT_AMOUNT, INSTALLMENT_CURRENCY, OUTSTANDING_BALANCE from AUDI_MW_CARD_ACTIVITY_TABLE_V1 where SERVICE_REFERENCE = ? failed.
Caused by java.sql.SQLException: Missing IN or OUT parameter at index:: 1.
; nested exception is:
BINDING.JCA-11633
Pure SQL Exception.
-----------------------
OSB-380001,BINDING.JCA-11633
Invoke JCA outbound service failed with application 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:/bus.svc/PowerCard/CardActivity/wsdl/bus_svc_PowerCard_CardActivityTable_getData.wsdl [ bus_svc_PowerCard_CardActivityTable_getData_ptt::bus.svc.PowerCard.CardActivityTable.getData(bus.svc.PowerCard.CardActivityTable.getDataInput_msg,bus.svc.PowerCard.CardActivityTable.getDataOutputCollection) ] - WSIF JCA Execute of operation 'bus.svc.PowerCard.CardActivityTable.getData' failed due to: Pure SQL Exception.
Pure SQL Execute of select CHANNEL, SERVICE_TYPE, SERVICE_REFERENCE, IDENTIFIER_ID, IDENTIFIER_TYPE, CR_ACCOUNT_NBR, TRANSACTION_REF_NUM, to_char(STATEMENT_DATE,'yyyy-mm-dd hh:mm:ss') , to_char(TRANSACTION_DATE,'yyyy-mm-dd hh:mm:ss'), TRANSACTION_TYPE, DEBIT_CREDIT_FLAG, BILLING_AMOUNT, BILLING_CURRENCY, MERCHANT_NAME, MERCHANT_CITY, TRANSACTION_AMOUNT, TRANSACTION_CURRENCY, TRANSACTION_DESC, TRANSACTION_STATUS, INSTALLMENT_AMOUNT, INSTALLMENT_CURRENCY, OUTSTANDING_BALANCE from AUDI_MW_CARD_ACTIVITY_TABLE_V1 where SERVICE_REFERENCE = ? failed.
Caused by java.sql.SQLException: Missing IN or OUT parameter at index:: 1.
; nested exception is:
BINDING.JCA-11633
Pure SQL Exception.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |