My Oracle Support Banner

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:

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

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

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


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