Modern UX Timesheets performance on Review and Approve for large datasets

book

Article ID: 143464

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

STEPS TO REPRODUCE:

1. On a large dataset pick a user with many resources reporting to them as manager

2. Go to New UX -> Timesheets -> Review and Approve

3. Do required for a resource manager actions:

a. Click on the Filter, select Resource, and double click on the drop down to see all results

b. Click on the Filter, select Resource, and type few letters in the drop down

c. Click on Open to see Open Timesheets

d. Click on Submitted to see Submitted Timesheets

e. Click on Approved

f. Click on Returned

Expected Results: All actions to perform within normal limits

Actual Results: All the actions are over 20 sec, with Filter being sometimes going to 45-1,10. Some actions go on for few minutes.
No spinning wheel is there for most actions.

Cause

This is caused by DE52677

One query that may show up as slow in tracing (such as action tracing) is the below query causing the slowness:
SELECT PRID, PRTIMESHEETID, PRACTCURVE
FROM TIMEENTRY
WHERE ? = ? OR PRTIMESHEETID in (?)

Environment

Release : 15.6, 15.6.1, 15.7, 15.7.1

Component : CA PPM TIME MANAGEMENT

Resolution

  • This issue is logged as DE52677, fixed in 15.6.1.4, 15.7.1.2, 15.8
  • Workaround: None or use Classic UX Timesheets for managers with multiple reportees
  • Contact Broadcom Support to see for fix possibilities in Production if high impact on users

Additional Information

  • See KB: 115739 - Slowness in New User Experience Timesheets in PPM for a defect fixed in 15.5.1 
  • See KB: 133605 - Unable to load timesheet data error occurs intermittently for some users in New UX
  • See KB 141061 - How to search for known Clarity PPM Issues using Self Service