My Oracle Support Banner

Error 'ORA-02291: integrity constraint (ARGUS_APP.FK_CODE_LIST_CODE_ATTRIBUTES) violated' in Upgrade From Argus 8.2.3.001 to 8.4.2 (Doc ID 3021464.1)

Last updated on MAY 10, 2024

Applies to:

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

Symptoms

The following error occurs in the dbinstaller log file while upgrading from Argus 8.2.3.001 to 8.4.2:

Running Changeset: changelogs/823_8231/factorydata/changelog.xml::70::safety-upgrade:lm_admin_route
ERROR in loading data : LM_ADMIN_ROUTE :  Line Number : 143
Unexpected error running Liquibase: liquibase.exception.MigrationFailedException: Migration failed for changeset changelogs/823_8231/factorydata/changelog.xml::70::safety-upgrade:lm_admin_route:
    Reason: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.CustomChangeException: ORA-02291: integrity constraint (ARGUS_APP.FK_CODE_LIST_CODE_ATTRIBUTES) violated - parent key not found
ORA-06512: at "ARGUS_APP.PKG_CONSOLE_FR_CODELIST", line 203
ORA-06512: at "ARGUS_APP.TRG_DV_LM_ADMIN_ROUTE", line 29
ORA-04088: error during execution of trigger 'ARGUS_APP.TRG_DV_LM_ADMIN_ROUTE'

 

Changes

 

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.