Risk/Issue/Change User View in MUX wiped out after upgrade to 15.9.2 and higher

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

User view on Issues/Changes/Risks is missing after upgrade to 15.9.2 and higher in Modern UX, while still in the database

STEPS TO REPRODUCE:

1. Create a user view on Issues with a regular user (on Clarity 15.9.1)
2. Ensure it works to open, view and edit
3. Now upgrade Clarity to a higher than 15.9.2 version, i.e.16.0.1

Expected Results: The view to still be available and accessible

Actual Results: View is no longer visible in the view dropdown, it's missing in UI. It is still present in ODF_UI_VIEWS for the same user

Environment

Release : 15.9.2+

Resolution

This is DE64765, this has been reviewed by Engineering and determined to be orphan records due to a change in 15.9.2 by moving the Risk/Change/Issue to the Investment object

Workaround

1. Run the following query on the database, starting with a lower environment: 

update odf_ui_views set ASSOCIATED_OBJECT_TYPE = 'inv' where id in (select id from ODF_UI_VIEWS where TYPE in ('risks','issues','changes') and ASSOCIATED_OBJECT_TYPE is null)

commit

2. Refresh the page