My Oracle Support Banner

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

Last updated on SEPTEMBER 21, 2020

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!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.