ODI Processing fails with ORA-01438 Error (Doc ID 2155823.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

Oracle Knowledge - Version 8.6 and later
Information in this document applies to any platform.

Goal

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:

Error:
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

Reason:
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.


 

Solution

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