Opening a project in Open Workbench is taking long time

Document ID : KB000031064
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Opening a project in Open Workbench (OWB) is taking long time.  A query to retrieve all the calendars associated to the project via roles and resources is taking more time than expected.

 

Steps to Reproduce:

  1. Add 10000+ calendar and 80K resources to the PPM application. 
  2. Create a project with 150+ tasks, 290+ team and 1900+ assignments. Make sure at least 200 resources in this team have roles associated to them.
  3. Open the project in OWB.  
Expected Result:  1 or 2 minutes to open the project in OWB
Actual Result: Taking more than 10 minutes to open the project in OWB
 

Solution:

WORKAROUND:

None.

STATUS/RESOLUTION:

CLRT-75438

Targeted for a resolution in an upcoming v13.3 Generic Patch.

Resolved in CA PPM 14.2