My Oracle Support Banner

Out Of The Box Oracle Knowledge 8.6 Installation May Fail During ODI ETL With ODI-1228 And ORA-01438 Errors In Task INT-INSERT_UPDATE_FACT_TOTAL_PUBLISH (Doc ID 2024938.1)

Last updated on MARCH 28, 2017

Applies to:

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


A brand-new Oracle Knowledge 8.6 Analytics installation with only a small set of initial data may fail during ODI ETL with the following error when running the task PKG-ORACLE_KNOWLEDGE_MAIN:

ODI-1228: Task INT-INSERT_UPDATE_FACT_TOTAL_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


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.