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

Last updated on MAY 01, 2020

Applies to:

Symptoms

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 12.2.1.3.190708 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.

Changes

Have applied <Patch 29778645>

Cause

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