MUX Timesheet Grid slow / hangs/ does not return when filtering on OBS (SQL Server)

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Performance Issue on Timesheets Grid using an OBS in the Filter Section. This was working well on 15.8.1 before upgrade. 

Steps to Reproduce:  

1. Connect to a large MSSQL environment with 2+ mln timesheets
2. Go to Timesheet Grid
3. Filter on a View with Resource OBS to return approximately 700-800 rows

Expected Results: View to return in a reasonable amount of time

Actual Results: The View is spinning for several minutes before returning. 

Environment

Release : 16.0.1, 16.0.2

Resolution

This is DE65376, fixed in 16.0.3 

Workaround: Use Manager as filter instead