My Oracle Support Banner

ODI 12c Mapping Execution Fails with "java.lang.ArrayIndexOutOfBoundsException" Error using LKM "SQL To Oracle" and "APPEND_VALUES" Hint (Doc ID 2467494.1)

Last updated on SEPTEMBER 14, 2023

Applies to:

Oracle Data Integrator - Version 12.2.1.1.0 and later
Information in this document applies to any platform.

Symptoms

An Oracle data Integrator (ODI) 12c mapping execution fails with an "java.lang.ArrayIndexOutOfBoundsException" error when the APPEND_VALUES Hint is used with LKM "SQL To Oracle" and both the "Array Fetch" and "Batch Update" parameters are set to a high value.

There is no issue if the "APPEND_VALUES" hint is not used.

Steps to reproduce the issue:

  1. Create two data server connections for two different schemas on Oracle database version 12.1.0.2 (11.2.0.4 was working)
  2. Change the "Array Fetch" and "Batch Update" size to 50000.
  3. Create a mapping that transfers a table between the two schemas
  4. Use the KM "LKM_SQL_to_Oracle" and any IKM (error is in the LKM)
  5. Set the LOAD_DIRECT option to TRUE (APPEND_VALUES) in "LKM_SQL_to_Oracle"
  6. Run the mapping

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.