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 27, 2019
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