Select Tasks in MUX Timesheets is slow starting 16.3.1

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

After upgrade to 16.3.1 and 16.3.1.1, the users notice slowness in the Select Tasks page in MUX with exact same view/data as prior to upgrade on 16.2.2.1

STEPS TO REPRODUCE:

1. Go to MUX Timesheets – open any timesheet for an active user with instance rights (use provided credentials below)
2. Click on Select Tasks
3. Note the time it takes
4. Now clear the Assigned User = Current User and note the time it takes

Expected Results: The results to be returned within timely limits

Actual Results: The query is spinning for over 30 sec, which may create bottlenecks and high CPU on the database 

Environment

Clarity 16.3.1, 16.3.2

Cause

DE171087

Resolution

Fixed in Clarity 16.3.3

Workaround:

1. Run the command on the app server:
   admin toggle-feature TIMESHEET_NO_STAFF_OR_ASSIGNMENT_F52325 0
2. Restart all services
3. Test the Select Tasks performance

• The impact of this is that you no longer will be able to submit time on Investments without being Staffed on them
• This is a new feature added in 16.3.1 so you may consider waiting and starting to use it in 16.3.3
• The feature was added to avoid having to fully staff Other Work investments
• To check if you have any investments enabled, run the query: 
  select count(*) from inv_investments where  ALLOW_UNSTAFFED_TIME_ENTRY =1