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 laterInformation 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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |