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.

Symptoms

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

Cause

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