Troubleshooting
Problem
Symptom
[exec] Repair resource records
[exec] Declare
[exec] *
[exec] ERROR at line 1:
[exec] ORA-00001: unique constraint (OPENPAGE.RESOURCES_UN) violated
[exec] ORA-06512: at line 13
[exec] ORA-06512: at line 13
[exec] Repair resource records
[exec] ERROR near line 310:
[exec] SQL0803N One or more values in the INSERT statement, UPDATE statement, or
[exec] foreign key update caused by a DELETE statement are not valid because the
[exec] primary key, unique constraint or unique index identified by "11" constrains
[exec] table "OPENPAGES.RESOURCES" from having duplicate values for the index key.
Diagnosing The Problem
Resolving The Problem
----------------------------------------------------------------------------------
-- 8.2.0.4.6 - PH46924 - Data cleanup - Start
----------------------------------------------------------------------------------
----------------------------------------------------------------------------------
-- 8.2.0.4.6 - PH46924 - Data cleanup - End
----------------------------------------------------------------------------------
For Db2, remove lines 65 through line 411. For Oracle, remove lines 62 through line 408.
After the edit, this section looks like:
----------------------------------------------------------------------------------
-- 8.2.0.4.6 - PH46924 - Data cleanup - Start
----------------------------------------------------------------------------------
----------------------------------------------------------------------------------
-- 8.2.0.4.6 - PH46924 - Data cleanup - End
----------------------------------------------------------------------------------
Insure that there is no code between the Start and End blocks.
Save the file and reapply the interim fix.
For 8.3.0.1, you must edit the dbu-30-opx-data-changes.sql under OP830X_TO_OP830X directory and find the section that begins with:
----------------------------------------------------------------------------------
-- 8.3.0.1 - PH46924 - Data cleanup - Start
----------------------------------------------------------------------------------
Delete everything between that comment and the following comment:
----------------------------------------------------------------------------------
-- 8.3.0.1 - PH46924 - Data cleanup - End
----------------------------------------------------------------------------------
For both Oracle and Db2, remove lines 420 through line 766.
After the edit, this section looks like:
----------------------------------------------------------------------------------
-- 8.3.0.1 - PH46924 - Data cleanup - Start
----------------------------------------------------------------------------------
----------------------------------------------------------------------------------
-- 8.3.0.1 - PH46924 - Data cleanup - End
----------------------------------------------------------------------------------
Insure that there is no code between the Start and End blocks.
Save the file and reapply the fix pack.
Document Location
Worldwide
Was this topic helpful?
Document Information
Modified date:
25 July 2022
UID
ibm16607035