Unable to switch views on the Project Status module

Products

• Clarity PPM On Premise
• Clarity PPM SaaS
• Clarity FedRAMP

Issue/Introduction

A specific user is unable to switch views on any project Status tab that he is able to view on Modern UX. His user permissions are the same as other users who are able to switch those views. What could be the reason?

Environment

Clarity All Supported Version 

Cause

Corruption of User personalization 

Resolution

• Get the user's numeric ID from CMN_SEC_USERS 

  SELECT id, user_name, full_name, email_address FROM cmn_sec_users WHERE user_name = '<username>';

• Query CMN_UI_PERSONALIZATIONS to find the component name and record ID for the status report module, Look for component values like status-report, statusReport, or similar. The exact name is set by the frontend when it saves personalizations. 

  SELECT id, user_id, component, last_updated_date FROM cmn_ui_personalizations WHERE user_id = (SELECT id FROM cmn_sec_users WHERE user_name = '<username>')ORDER BY component;

• In this case the component name will be 'projectStatusReportscanvas', 'projectStatusReports'
• Review the JSON in PERSONALIZATIONS to confirm it's the right record
• Call the REST API to delete:
  
  • DELETE /ppm/rest/v1/private/personalizations?filter=((component = 'projectStatusReportscanvas') and (userid = yyyyyy))
  • DELETE /ppm/rest/v1/private/personalizations?filter=((component = 'projectStatusReports') and (userid = yyyyyy))

Additional Information

The CMN_UI_PREFERENCES gets repopulated when the user logs back into Clarity PPM