My Oracle Support Banner

ODI 12c Mapping Reading Data from a File Fails After ODI Bundle Patch (Patch 29778645) (Doc ID 2644870.1)

Last updated on JANUARY 27, 2023

Applies to:

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


When attempting to run a Mapping in Oracle Data Integrator (ODI) that reads data from a source text File with EBCIDIC characters after applying ODI bundle patch (<Patch 29778645>), the following error is encountered:

ODI-1227: Task SERIAL-MAP_MAIN- fails on the source connection <Empty Value>.
ODI-1298: Serial task "<TASK NAME>" failed because child task "<CHILD TASK NAME>" is in error.
ODI-1298: Serial task "<CHILD TASK NAME>" failed because child task "Insert new rows-LKM SQL to Oracle (Built-In)-Load <LOAD NAME>" is in error.
ODI-1228: Task Insert new rows-LKM SQL to Oracle (Built-In)-Load <LOAD NAME> fails on the target connection <TARGET CONNECTION>.
Caused By: java.sql.BatchUpdateException: ORA-12899: value too large for column "<SCHEMA>"."C$_<TABLE>"."<COLUMN>" (actual: 118, maximum: 100)

The issue is experienced when the following is performed:

  1. Prior to Patch 29778645, the Mapping that reads data from a source File works without issue.
  2. Apply Patch 29778645, make no other changes and run the Mapping again.
  3. This time it fails with the error above.


Have applied Patch 29778645


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.