(SQL Server) Classic Timesheets Filter on Recent Adjustments is very slow

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

In Classic when filtering the Timesheets - every request is fast, but if we filter on Recent Adjustments it's very slow

 

STEPS TO REPRODUCE:

1. Connect to Clarity - Timesheets in Classic UI
2. Click on Show All. Note the time it takes (few seconds)
3. Now filter on Recent Adjustments

Expected Results: The results to return in comparable times

Actual Results: The page is very slow and takes 3+ minutes to return

 

 

Environment

Release : 16.0.0 with SQL Server 2019

Resolution

This is DE66866, fixed in 16.1.1

Workaround: Do not filter on Recent Adjustments