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 laterInformation 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'
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 |