Portlet gives System error to one user only (Corrupt filter)

book

Article ID: 197073

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

One of our portlets does not work for one user only. They get "ERROR" and nothing else. Restoring defaults does not work

Environment

Release : All Supported Clarity releases

Component : CA PPM STUDIO

Resolution

Issue is caused by a corrupt filter on this portlet, this is why restoring defaults does not work. Looking in the SQL trace, find the filter expression ids run for the exact same portlet with Support's help. Example queries to look for:

SELECT  a.*
          FROM     cmn_attribute_value_sets a
          WHERE    a.view_code = 5026088
          AND      a.user_id = 5289155  order by a.name
    
    
    SELECT * FROM odf_filter_expressions
          WHERE object_code = 5333564
          AND object_instance_id = 5753877
   

Once you identified the correct filter, run the query to fix the issue:
    update odf_filter_expressions
    set expression ='1==1'
    where id =5000000

commit

Flush the caches before testing again