Status Reports Not Loading in modern ux

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Status Reports Not Loading in modern ux for some projects  and error toast message "Could not load status report" 

Steps to Reproduce:

1. Login to modern ux with appropriate rights
2. Navigate to project and search for projects 
3. Click on the project and navigate to status module 

Actual Result: Toast error message "Could not load status report" and page is stuck 

Expected Result: Status page should load

Environment

Release : 16.0.0

Component : Clarity MUX UI Usability

Cause

This is due to data issue cmn_ui_preferences table for column preference is null and below query can be run to find out the impacted projects where status report is not loading 

select
 a.id,
 a.resource_name,
 a.resource_id,
 a.preferences,
 ii.name, ii.code
from
 cmn_ui_preferences a,
 inv_investments ii
where
 a.resource_name = 'projects'
 and a.preferences is null
 and a.resource_id = ii.id
 and ii.odf_object_code = 'project'

Resolution

Till the defect is fixed, below workaround can be used

 

1. Stop all the clarity services 
2. Take back up of table cmn_ui_preferences
3. Execute the below update
   • update cmn_ui_preferences
      set preferences = '[{"code":"highlevelstatusmodule","layout":{"sizeX":2,"sizeY":1,"row":0,"col":0}},{"code":"statusUpdate","layout":{"sizeX":1,"sizeY":1,"row":1,"col":0}},{"code":"keyAccomplishments","layout":{"sizeX":1,"sizeY":1,"row":1,"col":1}},{"code":"effortmetrics","layout":{"sizeX":1,"sizeY":1,"row":3,"col":0}},{"code":"costmetrics","layout":{"sizeX":1,"sizeY":1,"row":3,"col":1}},{"code":"nextweeks","layout":{"sizeX":2,"sizeY":2,"row":8,"col":0}}]'
      where resource_id in (
     select
      a.resource_id
     from
      cmn_ui_preferences a,
      inv_investments ii
     where
      a.resource_name = 'projects'
      and a.preferences is null
      and a.resource_id = ii.id
      and ii.odf_object_code = 'project')
4. Restart all the services