A User is unable to Access a List View or Portlet

book

Article ID: 16623

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

A user has saved a custom filter and is now unable to access a list view or portlet, such as the task list or Timesheet Review portlet. The page may spin for some time and eventually throw a system error. 

What can be done to allow the user to access this list view or portlet again?

Environment

Any CA PPM release

Resolution

When a user modifies and saves a filter, a record gets created in the cmn_attribute_value_sets table. If the filter gets saved as the default, then the specified filter is pushed as default when accessing that specific portlet/page. In order to allow the user to access this page/portlet again, the saved filter will need to be set to no longer be the default. The only way to do this is by updating the record in the database table. 

The following query can be used to check what custom default filters a user has set:

select * from cmn_attribute_value_sets
where is_default =1
and user_id = <internal id of the affected user>

Check the result set:
For example, for the task list, the results include one row where the code is projmgr.odfKeyTaskList and the ID is 5016000.
For portlets, the code will be the internal id of the portlet. The portlet internal ID can be gathered from the URL that is generated when going to the properties of that portlet under Administration - Portlets. 

To make the saved filter no longer be the default, run the following update in the database:

update cmn_attribute_value_sets
set is_default =0
where id = <id of value set pertaining to affected view or portlet>
and user_id = <internal id of the affected user>

After doing so, PPM will default to the OOTB filter and the portlet will load without error.