Staffing page is extremely slow in MUX due to a virtual attribute

Products

• Clarity PPM SaaS

Issue/Introduction

The staffing page is loading slow. After providing details in the required fields on the staffing page, it take more than normal time to save the data and the screen seems stuck till the record gets saved.

 

STEPS TO REPRODUCE: 
1- Login to  Modern UX 
2- Open a project and go to the Staff module
3- Click the plus sign to add a resource
4- Now go to the Role field, it will hang here for up to 15 - 20 seconds
The yellow banner (indicating it is still being saved, takes a while to turn white)

Expected Results: Field in project staff module  be responsive

Actual Results:  There are significant delays going field to field

Workaround: 
Wait for the Role field to populate after the save

or removed the derived attribute

Environment

Release : 15.9.2

Component : CA PPM Modern UX

Cause

A derived attribute was triggering a defect in the  query design behind the queries used for the Staffing Module

Resolution

DE61240