MUX Timesheet Grid page never loads when Totals column is included

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Summary: For a large dataset, the Timesheet grid page never loads when Totals column is included in the results. This causes the CPU at the DB to eventually hit 100% if they are not killed on time. The potential performance issue lies with the view - tim_timesheet_act_sum_v. 

 

Steps to Reproduce: 

1. Login to a 16.0.1 Clarity environment which has a large dataset (>300k timesheets)
2. Navigate to MUX --> Timesheet tab
3. Add the below columns to the List view
   Resource Name
   Resource ID
   Time Period Start Date
   Status
   Resource Manager
   Updated Date
   Posted Time
4. Use the below filters
   Active = yes
   Timesheet status = Open,Submitted and Returned
   OBS = Use a Resources OBS 
   Timeperiod = current period

Actual & Expected: 118 timesheet records are populated in the grid page pretty quickly

5. Add Totals Column to the Grid page and use the same filters as above 

 

Expected Results: Timesheet records are populated in the grid page pretty quickly. 

Actual Results: The page never loads. 

Workaround: Remove the Totals column. 

 

Environment

Release 16.0.1 

Cause

DE64943 

Resolution

DE64943 , resolved in 16.0.2