OK 18.104.22.168 ODI Processing Fails with ConstraintViolationException: ORA-00001 Error
Last updated on JULY 12, 2016
Applies to:Oracle Knowledge - Version 8.6 to 8.6 [Release 8.6]
Information in this document applies to any platform.
On : 22.214.171.124 version.
When executing the PKG-ORACLE_KNOWLEDGE_MAIN it will start the PKG_LOAD_DIM_STG_TABLES sub-package and fail with an error.
ODI-1240: Flow INT-LOAD_FACT_RECOMMENDATION_STG fails while performing a
Integration operation. This flow loads target table FACT_RECOMMENDATION_STG.
ODI-1228: Task INT-LOAD_FACT_RECOMMENDATION_STG (Integration) fails on the
target ORACLE connection ORACLE_SERVER.
Caused By: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DW_REPORTING.FACT_RECOMMENDATION_STG_PK) violate
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