One of our portlets does not work for one user only. They get "ERROR" and nothing else. Restoring defaults does not work
Release : All Supported Clarity releases
Component : CA PPM STUDIO
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