Adjusting column selections causes extreme slowness using group by in Staff grid

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Removing or adding columns when using group by in Staff grid causes slow performance (it can take up to 5 minutes for the page to display). Chrome shows a popup “Page Unresponsive” message while “Loading data…Please wait” displays in Clarity UI.

STEPS TO REPRODUCE: 

1. In the Modern User Experience (UX), create a new project with about 100 team members
2. Go to the Staff tab
3. In View Options, set the following:

• Select Per-Period Metrics of ETCs and Actuals
• Periods = Months
• Start Period = 2021-04
• Finish Period = 2022-04
• Total Columns = Grant Totals or Sum of Periods (happens with both)

     4. Select a Group by (Example: Resource)

     5. Click on the column panel and select (or unselect) a column

Expected Results: Page loads within a reasonable time

Actual Results: Page hangs and a popup window displays “Page Unresponsive” while “Loading data…Please wait” displays in the Clarity UI

Cause

This is caused by DE60938 and happens when Group By is used with larger staffed projects. 

Environment

Release : 15.9.2

Component : Modern UX Staff Grid

Resolution

This is fixed in 15.9.2 patch 1 and 15.9.3 as DE60938 

Workaround: Wait for the results to return or Remove the Group by

Additional Information

See also:

• Per Period Metrics known issues
• Per Period Metrics performance - best practices to prevent