ODI Processing fails with ORA-01438 Error
Last updated on SEPTEMBER 15, 2016
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.
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