Select Tasks in MUX on a very large investment takes on a lot of JVM memory

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Having very large projects with over 90k resources assigned as team, timesheets users go to MUX and use Select Tasks. This fetches all the 90k records in memory which takes 800-900M of memory for each request

STEPS TO REPRODUCE:

1. Connect to a very large system with 90k active users
2. Create a large Other Work investment by assigning all 90k users to its team
3. Now connect as a regular user go to your Timesheet in MUX and click on Select Tasks

 

Expected Results: the action to be reasonably fast and take a reasonable amount of JVM

Actual Results: The action is usually slow, takes 800-900M and if users open many requests will cause an OutOfMemory (OOM)

Environment

Release : 16.0, 16.0.1, 16.0.2

Cause

• Caused by Assigned Resources lookup returning 90k resources per Other Work
• This setup goes against our best practices
• To review the best practices, check Setting up Other Works for Other Time

Resolution

This is DE66092, addressed by a change in 16.0.3