ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Portlet errors/hangs when filtering on large data in GCP/Postgres

book

Article ID: 199958

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

Receive error after about 3-4 minutes in our custom timesheet portlet:
 
Error 500 - Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator.

Cause

Use of views such as DWH views can cause a slow down.

Environment

Release : 15.8.1

Component : CA PPM SAAS STUDIO

Resolution

Replace the DWH views in the portlet query with direct table access. If assistance is needed with this, please contact Broadcom support to see if there is anything further that can be done to assist.

Additional Information