My Oracle Support Banner

"ORA-00001: unique constraint (APR_MART.PK_CFG_GROUPS) violated" Error Encountered During The Upgrade From 4.2 Sp1 Hf1 To 4.2 Sp2 (Insight) (Doc ID 1361622.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Argus Insight - Version 4.2.1.1 to 4.2.2 [Release 4.2.0]
Information in this document applies to any platform.

Symptoms

Getting the following error when upgrading Argus Insight Database from 4.2 SP1 HF1 to 4.2 SP2:

Opening File .\Upgrades\42SP1HF1_TO_42SP2\Factory_Data\cfg_groups.sql

insert into cfg_groups (group_id, group_name, menu_access, company_defined) values(10,'Perceptive','A1|B11111101|C1111|D11111|E11111|F11111111|G11111111111|H1111|I11|J1|K1|L1111|M1|N1|O111111|P11111',1);
SQL execution error, ORA-00001: unique constraint (APR_MART.PK_CFG_GROUPS) violated
-- 6/16/2011 11:53:18 AM

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.