My Oracle Support Banner

Insight ETL Fails With Error - ORA-20010: ORA-00001: unique constraint (APR_MART.PK_RPT_EVENT_ASSESS) violated (Doc ID 2804988.1)

Last updated on JULY 13, 2023

Applies to:

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

Symptoms

 Argus Insight ETL (Initial and Incremental) fails with Error:

FAILED with Desctiption ORA-20010: ORA-20010: ORA-00001: unique constraint (APR_MART.PK_RPT_EVENT_ASSESS) violated ORA-06512: at "APR_MART.PKG_AIR_STOM", line 5022 -- ERROR while processing rpt_event_as

Changes

Recently MedDRA upgrade was done in Safety.

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
Changes
Cause
Solution

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