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 APRIL 14, 2021

Applies to:

Oracle Data Integrator - 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!

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.