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 JUNE 28, 2024
Applies to:
Oracle Data Integrator - Version 12.2.1.3.190708 and laterOracle Data Integrator on Marketplace - Version 12.2.1.4.200123 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:
- Prior to Patch 29778645, the Mapping that reads data from a source File works without issue.
- Apply Patch 29778645, make no other changes and run the Mapping again.
- 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! |