Odi Failed On ORA-12899: Value Too Large For Column (Doc ID 1675157.1)

Last updated on OCTOBER 13, 2016

Applies to:

Oracle Knowledge - Version 8.5.1 to 8.6 [Release 8.5 to 8.6]
Information in this document applies to any platform.

Symptoms

Examples of Error Messages:
---------------

Example 1:

MESSAGE:ODI-1226: Step INT-Load_DIM_QUESTION fails after 1 attempt(s).
ODI-1240: Flow INT-Load_DIM_QUESTION fails while performing a Integration operation. This flow loads target table DIM_QUESTN.
ODI-1228: Task INT-LOAD_DIM_QUESTION (Integration) fails on the target ORACLE connection ORACLE_SERVER.
Caused By: java.sql.SQLException: ORA-12899: value too large for column "DW_REPORTING"."I$_DIM_QUESTN"."LBL" (actual: 1616, maximum: 1000)

Example 2:

ODI fails with the following error. The I$ is a table created by ODI during the data load.
ODI-1228: Task INT-LOAD_DIM_REC (Integration) fails on the target ORACLE connection ORACLE_SERVER.
Caused By: java.sql.SQLException: ORA-12899: value too large for column "OKPROD_ODI_WORK"."I$_DIM_REC"."CASE_NUM" (actual: 97, maximum: 64)

Note: The above 2 are just examples. The same steps could be followed for any problematic columns

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms