Slow Portlet Performance for NSQL portlets using multi-select filtering

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Known Impacted Portlets: 

• Timesheet Review by Manager
• Custom portlets may also be impacted. 

Environment

Release : 15.8.1

Component : CA PPM SAAS STUDIO

Resolution

This issue is fixed in 15.8.1.1 (15.8.1 patch 1) and also targeted to be fixed in Clarity 15.9.

Additional Information

• See Error 500 when filtering on portlets / portlet hangs due to DB issue
• See Portlet errors/hangs when filtering on large data in GCP/Postgres - due to issue with design of portlet Query