My Oracle Support Banner

ODI Mapping Fails With "Java.lang.ArrayIndexOutOfBoundsException: Array Index Out Of Range: 0" (Doc ID 2455005.1)

Last updated on JUNE 05, 2023

Applies to:

JDBC - Version 12.1.0.2.0 to 12.1.0.2.0 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On : 12.1.0.2.0 version, Thin JDBC driver

ODI mapping fails with "Java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 0"

After having upgraded the backend database from 11.2.0.4 to 12.1.0.2, some of the ETL start to fail when "Batch Update Size" is set to 500. However, it is successful when set to 100.


ERROR
-----------------------


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Update the database from version 11.2.0.4 to 12.1.0.2.0
2. Open ODI Studio and navigate to Topology > Physical Architecture > Technologies > Oracle > Double click on the Data Server
3. Change the "Batch Update Size" to 500 and the "Array Fetch Size" to either 100 or 500
4. Save and close the Data Server
5. Execute the job called "<JOB>" and notice that the error stack above is presented

Changes

 

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.