DB Adapter Insert Operation Failing Intermittently with NullPointerException or ArrayIndexOutOfBoundsException (Doc ID 1332114.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle Service Bus - Version 11.1.1.3.0 to 11.1.1.6.0 [Release 11g]
Oracle SOA Suite - Version 11.1.1.3.0 to 11.1.1.6.0 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

In Oracle Service Bus (OSB) the following flow is implemented:
Business Service > DB Adapter (write) > Oracle Database

Intermittently at runtime the insert operation fails with the error:

BINDING.JCA-11616
DBWriteInteractionSpec Execute Failed Exception.


The cause of the error is due to:
- java.lang.ArrayIndexOutOfBoundsException
or
- java.lang.NullPointerException

<May 16, 2011 2:40:36 AM MDT> <Error> <JCA_FRAMEWORK_AND_ADAPTER> <BEA-000000> <servicebus:/WSDL/SalesOrder/APPROVE_SALES_ORDER_DB [ APPROVE_SALES_ORDER_DB_ptt::insert(XxatExportCompInHdrIntfCollection) ] - Rolling back JCA LocalTransaction>
<May 16, 2011 2:40:36 AM MDT> <Error> <JCATransport> <BEA-381967> <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:/WSDL/SalesOrder/TC_Approval/Adapters/Target/OracleApps/APPROVE_SALES_ORDER_DB_ptt [ APPROVE_SALES_ORDER_DB_ptt_ptt::insert(XxatExportCompInHdrIntfCollection) ] - WSIF JCA Execute of operation 'insert' failed due to: DBWriteInteractionSpec Execute Failed Exception.
insert failed. Descriptor name: [APPROVE_SALES_ORDER_DB_ptt.XxatExportCompInHdrIntf].
Caused by java.lang.ArrayIndexOutOfBoundsException: 1.
; nested exception is:
BINDING.JCA-11616
DBWriteInteractionSpec Execute Failed Exception.
insert failed. Descriptor name: [APPROVE_SALES_ORDER_DB_ptt.XxatExportCompInHdrIntf].
Caused by java.lang.ArrayIndexOutOfBoundsException: 1.
Please see the logs for the full DBAdapter logging output prior to this exception.  This exception is considered not retriable, likely due to a modelling mistake.


or

<Mar 12, 2011 12:35:48 AM PST> <Error> <JCA_FRAMEWORK_AND_ADAPTER> <BEA-000000> <servicebus:/WSDL/DBAdapter/InsertCustomerEvent/InsertCustomerEvent [
InsertCustomerEvent_ptt::insert(CustomerEventCollection,CustomerEventCollectio
n) ] - Could not invoke operation 'insert' due to:

BINDING.JCA-11616
DBWriteInteractionSpec Execute Failed Exception.
insert failed. Descriptor name: [InsertCustomerEvent.CustomerEvent].
Caused by java.lang.NullPointerException.
Please see the logs for the full DBAdapter logging output prior to this
exception. This exception is considered not retriable, likely due to a
modelling mistake.

at
oracle.tip.adapter.db.exceptions.DBResourceException.createNonRetriableExcepti
on(DBResourceException.java:653)
at

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms