Performance issues with Portlet Pages (Administration) in one or more Clarity environments
Steps to Reproduce:
Expected Results: Page returns quickly
Actual Results: Takes anywhere from 5-40 minutes to open any portlet page from the administration side / Create page for new pages.
This is due to a slow running query on the Database.
Example of a slow running query in this instance may include:
FROM cmn_portlets portlet,cmn_captions_nls cc
WHERE cc.pk_id = portlet.id
AND cc.table_name = :"SYS_B_0"
AND cc.language_code = :v0
AND portlet.portlet_view_type_code = :v1
Release : All Supported Releases
Component : CA PPM SAAS INSTALLATION AND UPGRADE
On Premise customers:
Clarity PPM SaaS Customers: Contact Broadcom Support for assistance