Odi Failed On ORA-12899: Value Too Large For Column
Last updated on MARCH 02, 2018
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