Incremental ETL Failed With an Error "ORA-00001: unique constraint (APR_MART.PK_RPT_CASE_SUMMARY_REPORTS) violated" (Doc ID 1268183.1)

Last updated on JULY 26, 2012

Applies to:

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

Symptoms

Incremental ETL is failing with the following error:

Error Messages:
ORA-00001: Unique constraint (APR_MART:PK_RPT_CASE_SUMMARY_REPORTS) violated Error during data population info rpt_case_Summary for new reports (CASE_ID: XXXXXX)

Steps to Repeat:
1. Open a case that contains expedited reports and the case is already present in the MART database
2. Add a significant follow-up to the case
3. Remove an expedited report from the case
4 . Save the case
5. Run the incremental ETL in Insight
6. Observe that incremental ETL fails with the following error:

Error Messages:
ORA-00001: Unique constraint (APR_MART:PK_RPT_CASE_SUMMARY_REPORTS) violated Error during data population info rpt_case_Summary for new reports (CASE_ID: XXXXXX)

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