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.
Release 16.0.1
DE64943
DE64943 , resolved in 16.0.2