search cancel

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


Article ID: 243515


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


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. 


Release : 16.0.1, 16.0.2


This is DE65376, fixed in 16.0.3 

Workaround: Use Manager as filter instead