My Oracle Support Banner

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

Last updated on OCTOBER 26, 2020

Applies to:

JDBC - Version and later
Information in this document applies to any platform.


On : version, Thin JDBC driver

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

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


The issue can be reproduced at will with the following steps:
1. Update the database from version to
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




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

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