MUX Timesheets unusable when filtered by a Resource Last Name ends with "eval"
search cancel

MUX Timesheets unusable when filtered by a Resource Last Name ends with "eval"

book

Article ID: 279625

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

MUX Timesheet pages become unusable if a filter is set over a resource whose LastName ends up with "eval"

STEPS TO REPRODUCE:

  1. Create a resource or update an existing one, and set the last name as 'eval', or anything that ends up with 'eval', let's say Perceval
  2. Go to MUX > Timesheets
  3. On the Resource or Resource Manager filter field. select the resource above: Perceval
  4. Data is filtered correctly
  5. Close the tab
  6. Open another tab and navigate again to the MUX > timesheets

Expected Results: Data to get filtered over the previous criteria
Actual Results: The page is unusable and does not load.

Environment

Clarity 16.1.X, 16.2, 16.2.1

Cause

This is caused by DE79738

Resolution

This is fixed in 16.2.2

Workaround: 
1. Change the user's LastName to Perceval_
2. Delete the cmn_ui_personalizations record that is causing the timesheet page to hang
   Delete from cmn_ui_personalizations where component='timesheet' and id = xxxxxx (This would be the ID of the corrupted row)

Additional Information

Check the cmn_ui_personalizations table:
select * from cmn_ui_personalizations where component='timesheet' 
Look at the personalizations content that got corrupted.

A correct entry would look like:
{"timesheet":{"reviewAndApprove":{"selectionState":["1"],"activeResourceFilter":"myTeam","resourceManager":{"name":null,"id":null}},"staff":{"filter":{"resource":"5004004","resourceobjectDisplay":"[{\"displayValue\":\"FirstName LastName (FirstNameLastName)\",\"id\":5004004}]","resourceDisplay":"FirstName LastName (FirstNameLastName)","filterQuery":"not-implemented"}}}}

The corrupted one looks like
{\"timesheet\":{\"reviewAndApprove\":{\"selectionState\":[\"1\"],\"activeResourceFilter\":\"myTeam\",\"resourceManager\":{\"name\":null,\"id\":null}},\"staff\":{\"filter\":{\"resource\":\"5004025\",\"resourceobjectDisplay\":\"[{\"displayValue\":\"FirstName Perceval (FirstName Perceval)\",\"id\":5004025}]\",\"resourceDisplay\":\"FirstName Perceval (FirstName Perceval)\",\"filterQuery\":\"not-implemented\"}}}}