Could not load the view columns error found for custom object Grid layout in MUX

Products

• Clarity PPM On Premise

Issue/Introduction

Few users in the system are getting "Could not load the view columns"  error toast message for particular subobject of the project object. 

The affected Users are unable to see Standard View for this sub object either. There is no specific errors in the app logs and HAR file also did not showing error.

Environment

Release : 16.0.2

Resolution

The Personalization record for this user for the concerned custom object component was referencing a problematic view as the selected view. The view shown on the UI is different to that on select view in the personalization record. 

SQL query to get the personalization data (Substitute with the affected users internal ID and custom objects API attribute ID)

SELECT personalizations FROM CMN_UI_PERSONALIZATIONS cup WHERE USER_ID=5xxxx AND COMPONENT=custOBJECT

Sample personalization output:

PERSONALIZATIONS" : {"excludedViews":[],"selectedLayout":null,"flyoutConfig":{"expand":false,"width":33},"selectedView":5xxxxxx}

The corrupt view can be further updated from the UI and if not, then the same can be dropped via the following SQL update queries:

DELETE  FROM odf_ui_views  WHERE id = 5xxxxxx;

DELETE  FROM odf_ui_view_TARGET WHERE view_id = 5xxxxxx;

DELETE  FROM odf_ui_view_settings WHERE view_id = 5xxxxxx;

DELETE  FROM odf_ui_view_blueprints WHERE view_id = 5xxxxxx;

DELETE  FROM odf_ui_list_cols WHERE view_id = 5xxxxxx;