Action Items -> Closed tab is slow

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

• Modern UX is under use
• Specifically the My Workspace -> Action Items -> Closed tab
• Here, it is noticed that if there are more than 10 Action Items, it takes nearly a minute for the tab to load
• app-trace.xml records the following:
  <rest requestId="2e84f395ad" id="retrieve: /v1/actionItems" elapsed="45,000.000" elapsedAfterLastNode="0.000" start="2:17:34:824" finish="2:19:16:883" memoryDelta="24015k">

Environment

• Clarity 16.2.1

Resolution

• Not reproducible outside of the affected system
• It is clear from the app-trace.xml that the slowness is induced due to slowness in executing a SQL query at the DB
• Work with a DBA to understand if the query can be made to execute faster.