Incremental ETL is failing with the error "ORA-00001: unique constraint (APR_MART.PK_DM_MEDDRA_SMQ_CONTENT) violated"
Last updated on OCTOBER 24, 2013
Applies to:Oracle Argus Insight - Version 7.0.2 and later
Information in this document applies to any platform.
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:
Line: line 199
This is the script in the above package that the application is trying to execute:
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
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