DE59785 GCP - OutOfMemory error on Projects/Investments - cache is not sized enough for large number of API enabled attribute in Modern UX

book

Article ID: 208642

calendar_today

Updated On:

Products

STARTER PACK-CLARITY PPM Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

STEPS TO REPRODUCE:

  1. Enable with API alias a large number of custom attributes in Modern UX:
  • "inv"      "110"
  • "project"             "95"
  • "cop_prj_statusrpt"        "41"
  1. Once done, use the system and monitor the Cache Controller in the heap
  2. Note it's going up every day

 

Expected results: The Cache should get to a point where it will recycle entries and not grow

Actual Results: The app server eventually crashes with OutOfMemory error (OOM)

In the heap dump we notice:

ODF-PMD.ASSIGNMENT.SELECT.MAP-REST-API:CONTEXTID=5040101%HIERARCHYID=-1

ODF-PMD.ASSIGNMENT.SELECT.MAP-REST-API:CONTEXTID=5098210%HIERARCHYID=-1

ODF-PMD.PROJECT.SELECT-CONTEXT-ONLY-NO-SECURITY.MAP:CONTEXTID=5079290%HIERARCHYID=-1

 

==============================================================

 

PMD-STATEMENTS cache is full, over 12k statements cached, many of them 1MB+ in size due to "params" at the project/investment level, many of the other cached statements appear to be new UX related for projects/tasks/assignments

Environment

Release : 15.9, 15.9.1

Component : CA PPM SAAS INSTALLATION AND UPGRADE

Resolution

This is DE59785, fixed in 15.9.2