IBM Support

OpenPages 8.2.0.4.6 and 8.3.0.1 database upgrades can fail due to cleanup associated to PH46924

Troubleshooting


Problem

The OpenPages 8.2.0.4.6 and 8.3.0.1 database upgrades contain logic to repair objects that are missing the .txt extension that was caused by PH46924.  In some scenarios, this logic can fail with a duplicate key violation causing the upgrade to fail.

Symptom

You encounter a constraint violation applying the 8.2.0.4.6 interim fix or the 8.3.0.1 fix pack,
For Oracle, the error is:
     [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
For Db2, the error is:
[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.

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSFUEU","label":"IBM OpenPages with Watson"},"ARM Category":[{"code":"a8m50000000ClDPAA0","label":"Database"},{"code":"a8m50000000Ck26AAC","label":"Installation"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.2.0;8.3.0"},{"Product":{"code":"SS4PJS","label":"IBM OpenPages on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
08 May 2025

UID

ibm16607035

Page Feedback