configuration wheel missing for a user/view

Products

• Clarity PPM On Premise

Issue/Introduction

A user is trying to configure the Task Properties -> Assignments view, but the "Configure" option is missing. What could be the reason?

The configuration wheel can appear missing for a specific user on any Classic PPM view: assignments, project list, resource list.

This KB refers to the assignment view as an example, but you might face the same on any other Classic PPM view

Environment

Any Clarity PPM release

Cause

Unknown.

Resolution

When a Clarity  user configures a list view, the cmn_grids table is populated with an entry.
Run the following select query in order to find out which views have been configured by that user:
select * from cmn_grids where principal_id = XXXXX (The principal_id column is the UserID affected)

You will get the set of portlets that have been configured by the user.
Check the code column of the result set from the query above to identify the exact row affected.

The row that we are interested on, is the one with code: projmgr.taskAssignmentList

Check the ALLOW_EDITING, ALLOW_CONFIGURE and ALLOW_CONFIGURE_LABEL columns.
Their values should be set to 1 for the Configure option to be available.
If these are set as 0, the row should be updated:
UPDATE cmn_grids SET ALLOW_CONFIGURE=1,ALLOW_EDITING=1,ALLOW_CONFIGURE_LABEL=1 where code='projmgr.taskAssignmentList' and principal_id = XXXX (userID affected)