My Oracle Support Banner

"java.lang.ArrayIndexOutOfBoundsException" Error Received in ODI After Upgrading Oracle Database from 11.2.0.4 to 12.1.0.2.0 (Doc ID 2456848.1)

Last updated on MAY 08, 2023

Applies to:

Oracle Data Integrator - Version 12.1.3.0.0 to 12.1.3.0.1 [Release 12c]
Information in this document applies to any platform.

Symptoms

After upgrading the Oracle database from version 11.2.0.4 to 12.1.0.2.0 and setting the "Batch Update Size" to 500 via Oracle Data Integrator (ODI) Studio, the following error is encountered when running a job:


Steps to Reproduce Issue
The issue can be reproduced at will with the following steps:

1. Update the Oracle 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 the affected Oracle Data Server name.
3. Change the "Batch Update Size" to 500 and "Array Fetch Size" to at least 500.
4. Save and close the Data Server.
5. Execute an ODI 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!

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