Clarity 16.2.3 upgrade fails on a post step with POSTUPGRADE_NEW_AUDITS_VIEWS_PERSONALIZATION.xml

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

16.2.3 upgrade fails regarding a unique constraint violation on CMN_UI_PERSONALIZATION

Steps to Reproduce:

1. Attempt an upgrade to Clarity 16.2.3 

Expected Results: Upgrade should complete successfully

Actual Results: Upgrade fails with below error 

Process - post-upgrade: POSTUPGRADE_NEW_AUDITS_VIEWS_PERSONALIZATION.xml
8/30/24, 12:40 AM (admin) org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "cmn_ui_personalizations_u1"
8/30/24, 12:40 AM (admin)   Detail: Key (user_id, component)=(5006000, attrAuditsidea) already exists.
8/30/24, 12:40 AM (admin)   Where: SQL statement "INSERT INTO cmn_ui_personalizations

 

Environment

16.2.3

Cause

DE153551

Resolution

DE153551, fixed as part of release-overrides update for 16.2.3 (see below):

To fix this issue as part of 16.2.3 upgrade (if environment is not yet upgraded)

1. Download the above release-overrides.10.zip, unzip into a folder called <release-override-path> (c:\rel-overrides\)
2. Start the upgrade by running the install.sh or install.bat
3. In between the upgrade, there will be a prompt to enter the path for release-overrides the folder, provide the downloaded release-overrides.10.zip
4. Continue with the upgrade process.

Note: release-overrides.10.zip will be available under download section of product download from support.broadcom.com

Additional Information

When upgrading to 16.2.3 and you are not currently using Clarity Modern UX and OKR then please skip the usage of override in the upgrade.