ODI Processing fails with ORA-01438 Error
(Doc ID 2155823.1)
Last updated on AUGUST 15, 2018
Applies to:Oracle Knowledge - Version 8.6 and later
Information in this document applies to any platform.
On : 8.6 version, Oracle Knowledge Analytics
ODI processing is failing in the subpackage PKG_LOAD_FACT_ADD_TABLES_PUBLISH.
The Interface: INT-INSERT_UPDATE_FACT_CONTENT_B_PUBLISH in the Step: Insert flow into I$ table causing the exception:
ODI-1228: Task INT-INSERT_UPDATE_FACT_CONTENT_B_PUBLISH (Integration) fails on the target ORACLE connection ORACLE_SERVER.
Caused By: java.sql.SQLDataException: ORA-01438: value larger than specified precision allowed for this column
The RATING column is defined as NUMBER(3,1), but there is data coming through with a RATING value of "100", which will not fit in a NUMBER(3,1) column.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!