"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 SEPTEMBER 23, 2011

Applies to:

Oracle Argus Insight - Version: 4.2.1.1 to 4.2.2 - Release: 4.2 to 4.2
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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms