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:
Primavera P6 Enterprise Project Portfolio Management - Version 16.1.2.0 and laterInformation in this document applies to any platform.
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
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 |