My Oracle Support Banner

Initial ETL Failing With Unique Constraint Error On P_BAL_ARGUS_TO_STAGE_INI (Doc ID 2121383.1)

Last updated on MARCH 28, 2016

Applies to:

Oracle Argus Insight - Version 7.0.1 and later
Information in this document applies to any platform.

Symptoms

After refreshing a non-production Argus Safety system with production data, the associated Argus Insight Initial ETL began to fail with the following error:

ID: 2071297
Table Name: p_bal_argus_to_stage_ini
Description: Error while executing intial etl procedure - p_bal_argus_to_stage_ini
Error Description: ORA-20009: ORA-00001: unique constraint (APR_MART.PK_BAL_ARGUS_TO_STAGE_INI) violated
ORA-06512: at "APR_MART.PKG_BALANCING", line 101


In the Initial_ETL_Error_in_staging_data_insert_log the following error is associated with CMN_REG_REPORTS:

ORA-20009: ORA-00001: unique constraint (APR_MART.PK_BAL_ARGUS_TO_STAGE_INI) violated
ORA-06512: at "APR_MART.PKG_BALANCING", line 101

-- ERROR while processing p_bal_argus_to_stage_ini at 24-mar-2016 15:32:04

 

Cause

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
Symptoms
Cause
Solution
References


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