My Oracle Support Banner

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

Last updated on OCTOBER 04, 2018

Applies to:

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


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

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(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.processError(
at oracle.jdbc.driver.T4CTTIfun.receive(
at oracle.jdbc.driver.T4CTTIfun.doRPC(
at oracle.jdbc.driver.T4C8Oall.doOALL(
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.