Cannot Access Project List after GCP Migration

Products

• Clarity PPM SaaS

Issue/Introduction

Users cannot access the Project list, as well as the list views for some other investments, after migrating to GCP. 

When attempting to go to these list views, the page just spins and never comes up. This is the same behavior for all users. 

There are no errors in the app-ca logs, and no changes have been made to these views. 

Environment

Release : 15.8

Component : CA PPM SAAS APPLICATION

Resolution

This can occur if there is a report query that is stuck running in the background. The only way to resolve it is to open a case with Broadcom Support to have the DBA team kill the problematic query at the database level.