search cancel

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

book

Article ID: 243515

calendar_today

Updated On:

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