Incremental ETL Is Failing For Argus Mart - unique constraint (AM_STAGE_USER.I_SCMN_PROFILE_GLOBAL) violated (Doc ID 2045975.1)

Last updated on MARCH 27, 2017

Applies to:

Oracle Argus Mart - Version 7.0.3 and later
Information in this document applies to any platform.

Symptoms

Production - Incremental ETL is failing for Argus Mart ODI from last two with below error message

Problem Description
---------------------------------------------------
ODI-1519: Serial step "root_step (InternalID:2589)" failed because child step "SCN_populate_profile_switches (InternalID:190589)" is in error.
ODI-1217: Session SCN_populate_profile_switches (15393564) fails with return code 1.
ODI-1226: Step PRC_populate_profile_switches fails after 1 attempt(s).
ODI-1232: Procedure PRC_populate_profile_switches execution fails.
ODI-1228: Task PRC_populate_profile_switches (Procedure) fails on the target ORACLE connection DS_AM_ARGUSMART.
Caused By: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (AM_STAGE_USER.I_SCMN_PROFILE_GLOBAL) violated
ORA-06512: at "AM_STAGE_USER.PKG_SM_DTOS", line 243
ORA-06512: at line 3



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