Incremental ETL is failing with the error "ORA-00001: unique constraint (APR_MART.PK_DM_MEDDRA_SMQ_CONTENT) violated" (Doc ID 1594960.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

Incremental ETL Failed with the following error message:

ETL_JOBS: This showed us that the error is occurring on “Incremental Process for Staging to Mart”

This is the full error in the ORA_ERR_DESC field:

ORA-00001: unique constraint (APR_MART.PK_DM_MEDDRA_SMQ_CONTENT) violated
ORA-06512: at "APR_MART.PKG_AIR_STOM_SUB", line 199

Unique Constraint violated / ORA-00001 is common when a program tries to insert a “duplicate” row in a table and when a unique constraint is violated the row is NOT added to the.

The error message shows us that this is where the problem is:
Package: APR_MART.PKG_AIR_STOM_SUB
Line: line 199

This is the script in the above package that the application is trying to execute:

INSERT INTO
  dm_meddra_smq_content (global_dict_id, smq_code, term_addition_version, term_category, term_code, term_last_modified_version, term_level,
  term_scope, term_status, term_weight)
  (SELECT global_dict_id, smq_code, term_addition_version, term_category, term_code, term_last_modified_version, term_level,
  term_scope, term_status, term_weight
  FROM smeddra_smq_content);

Cause

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