Delay/slowness in the APM module after populating with application assessment data

book

Article ID: 125752

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

When the users launch the Dashboard for APM Module and its very slow and eventually it just hung.

Environment

Release:
Component: PPMENV

Resolution

DE44588, Engineering analysis of this issue indicated it is an expensive fix. At this time they are not going to fix this issue as Too Expensive to Fix.

Additional Information

Workaround:
1.  Remove the (max( apm_app_assess.assessment_date,"EQUALS",apm_app_assess.assessment_date )) part of the ACA filter on the Technical Score, Risk Score, Value Score, Mission Critical Level ACAs.
2. Ensure that there is only 1 assessment sub-object instance for an application that has an assessment status = 'FINAL'. This is something that could be enforced by a process on the assessment sub-object, for example, or a best-practice that the enterprise adheres to.