Portlet Spinning and unable to load data

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

A single user has created a filter or power filter, saved the filter and set it as a default filter.  Now the portlet will no longer load.  The progress circle in the browser just keeps spinning.  

Environment

Release: All supported clarity version 

Resolution

Steps to fix this issue:

For SaaS Customer Broadcom Support will help in  executing steps anything related to database 

If you are an On Premise customer, please contact Technical Support before you run the delete query to make sure this is the correct resolution for your problem.

• Determine the name of the portlet.
• Go to Administration, Portlets.  Locate and open the portlet to the properties page.
• Record the portlet id from the URL.  You will see "portletId=xxxxxxx"  where xxxxxxx is the number/portlet id you want.
• Go to Administration, Users (or Resources) and locate and open the properties page for your problem user.
• Record the user id from url.  It will be the number after id=.  Do not choose the one after resourceId=
• Now run the following query.  It should return only 1 row:

select * from cmn_attribute_value_sets
where created_by = xxxxxxx
and view_code = 'yyyyyyy'
and is_default = 1 

where xxxxxxx is the number recorded in Step 5 and yyyyyyy is the number recorded in Step 3.  NOTE:  The apostrophes are required in the and view_code= line.

• Run the following query to delete that filter (please keep a backup for table cmn_attribute_value_sets  before executing delete statement)

delete from cmn_attribute_value_sets 
where created_by = xxxxxxx 
and view_code = 'yyyyyyy' 
and is_default = 1;

where xxxxxxx is the number recorded in Step 5 and yyyyyyy is the number recorded in Step 3.  NOTE:  The apostrophes are required in the and view_code= line.