ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

MUX Timesheet Grid page never loads when Totals column is included

book

Article ID: 240952

calendar_today

Updated On:

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. 

 

Cause

DE64943 

Environment

Release 16.0.1 

Resolution

Resolved in 16.0.2