ODI Load Failure - Exception Occurred at Step:INT-LOAD_FACT_CONTENT_STG_REC_SUBMITTED (Doc ID 2148627.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

ODI error processing a record.
This will cause ODI processing to stop and can hold up analytics processing.
Version: 8.5.1.5

Oracle Knowledge ODI threw an exception, see details below:

----------------
ODI Session No:10937101
ODI Context:Global
ODI Session Started:2016-05-23 18:12:52.0 ODI Exception Occurred:2016-05-23 19:01:24.0 Exception Occurred at Step:INT-LOAD_FACT_CONTENT_STG_REC_SUBMITTED
ODI Agent Server Name:klmap-3911
ODI Repository DB Name:KLM1P1
DW Stage DB Name:KLM1P1
DW Reporting DB Name:KLM1P1


Error Message:
---------------
MESSAGE:ODI-1226: Step INT-LOAD_FACT_CONTENT_STG_REC_SUBMITTED fails after 1 attempt(s).
ODI-1240: Flow INT-LOAD_FACT_CONTENT_STG_REC_SUBMITTED fails while performing a Integration operation. This flow loads target table FACT_CONTENT_STG.
ODI-1228: Task INT-LOAD_FACT_CONTENT_STG_REC_SUBMITTED (Integration) fails on the target ORACLE connection ORACLE_SERVER.
Caused By: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DW_REPORTING.FACT_CONTENT_STG_PK) violated

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)

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