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