When the users launch the Dashboard for APM Module and its very slow and eventually it just hung.
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.
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.