Error 'ORA-00001: unique constraint ADMUSER.NDX_SETTING_ID) violated' When Upgrading a P6 Database Using the 'Dbsetup' Utility (Doc ID 2479589.1)

Last updated on MARCH 22, 2022

Applies to:

Symptoms

When attempting to upgrade a P6 database to release 17.12, the following error occurs:

ERROR

ORA-00001: unique constraint ADMUSER.NDX_SETTING_ID) violated
ORA-06512: at line 13
SQL Query:
DECLARE
  CURSOR auditing_cur
  IS
  select setting_id, namespace, setting_name
  from settings where namespace like 'database.audit%' and setting_id is null;
  v_settings_setting_id NUMBER;
  v_count NUMBER :=0;
BEGIN
  FOR r_auditing_cur IN auditing_cur
  LOOP
  getnextkeys('settings_setting_id', 1, v_settings_setting_id);
  v_settings_setting_id:=v_settings_setting_id;
  update settings set setting_id = v_settings_setting_id
  where namespace=r_auditing_cur.namespace and
  setting_name=r_auditing_cur.setting_name;
  END LOOP;
  COMMIT;
END;

The issue can be reproduced at will with the following steps:

1. Launch the <P6 EPPM install media>\database\dbsetup.bat (/.sh) utility.
2. Step through the process to upgrade the database.
3. Upgrade fails with the reported error.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.