My Oracle Support Banner

Getting "ORA-00001: unique constraint (ARGUS_APP.PK_CFG_PLACEHOLDERS) violated" Error When Upgrading Argus Safety From V7.0.2 To V7.0.3 (Doc ID 2141335.1)

Last updated on SEPTEMBER 11, 2018

Applies to:

Oracle Argus Safety - Version 8.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 11-SEP-2018***

Symptoms

Getting the following error when upgrading Argus Safety from v7.0.2 to v7.0.3

"Upgrade Execution has completed. Number of errors during upgrade = 1"

Database upgrade did not stop on the error even though we had checked the "Pause on error" check box

The following error is written in the database upgrade log:

insert into cfg_placeholders(place_id, place_holder_type, place_holder, sql_query) values(742, 0, '[reporter_inst_id:primary]', 'select institution_id from case_reporters where case_id=:P_LET_CASE_ID and primary_contact = 1')
FAILED: ORA-00001: unique constraint (ARGUS_APP.PK_CFG_PLACEHOLDERS) violated

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
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.