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 |