While Implementing Argus 8.1.2.5, Unique Constraint Error On TRG_DV_LM_DOSE_UNITS While Running DbinstallerUI.bat
(Doc ID 2566753.1)
Last updated on JULY 13, 2023
Applies to:
Oracle Life Sciences Argus Safety - Version 8.1.2 and laterInformation in this document applies to any platform.
Symptoms
On Applications : 8.1.2.5
Implementing/applying Argus Safety Patch 8.1.2.5 to existing Argus Safety 8.1.2.3 Environment.
Whilst running the dbinstallerUI.bat it is throwing the below unique constraint error
ERROR in loading data : LM_DOSE_UNITS : Line Number : 143
Jun 18, 2019 9:07:41 AM Safety.Database.LiquibaseCustom.DataTableModel LoadUpdateDataFromCSV
SEVERE: null
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ARGUS_APP.PK_CODE_LIST_CODE_ATTRIBUTES) violated
ORA-06512: at "ARGUS_APP.PKG_CONSOLE_FR_CODELIST", line 130
ORA-06512: at "ARGUS_APP.TRG_DV_LM_DOSE_UNITS", line 165
ORA-04088: error during execution of trigger 'ARGUS_APP.TRG_DV_LM_DOSE_UNITS'
Jun 18, 2019 9:07:41 AM Safety.Database.LiquibaseCustom.DataTableModel LoadUpdateDataFromCSV
SEVERE: null
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ARGUS_APP.PK_CODE_LIST_CODE_ATTRIBUTES) violated
ORA-06512: at "ARGUS_APP.PKG_CONSOLE_FR_CODELIST", line 130
ORA-06512: at "ARGUS_APP.TRG_DV_LM_DOSE_UNITS", line 165
ORA-04088: error during execution of trigger 'ARGUS_APP.TRG_DV_LM_DOSE_UNITS'
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 |
| References |