Modern UX timesheet continuously loops
search cancel

Modern UX timesheet continuously loops

book

Article ID: 231279

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

Since we activated the timesheets in the modern ux, we have problems on the tab "My timesheet", the tab does not display anything and seems to run in a loop to refresh itself

Environment

Release : 16.0.0

Component : CLARITY TIME MANAGEMENT

Cause

At this point its unknown how the problem surfaced however review of the seed data on the instance when problem was seen the data seems to be updated. By default there are 3 records seeded by product and it can be verified by running the below query and on the system where problem was seen the user_id with component ='timesheet' was updated 

SELECT *  from CMN_UI_PERSONALIZATIONS
WHERE user_id = 0

id user_id component personalizations created_by created_date last_updated_by last_updated_date
5000000 0 resource {"resource":{"underThreshold":30,"overThreshold":10,"grid":{"units":"fte","numDecimals":2},"ttc":{"start":"current","tiers":{"tier1":{"type":"MONTHLY","number":24}},"selection":{"offset":0,"tiers":[{"type":"MONTHLY","count":12}]}}}} 1 2/23/2017 1 2/23/2017
5000001 0 project {"project":{"documents":{"documentsList":{"sort":{"orderByField":"modified","reverseSort":true}}},"financials":{"finPlans":{"sort":{"sortColumn":"createdDate","sortByDesc":true}}},"tasks":{"view":"board","filter":{"query":{"raw":"","formatted":""},"selectedFilter":{"index":0,"id":"allTasks","queryParams":""}}}}} 1 8/23/2017 1 8/23/2017
5000002 0 timesheet {"timesheet":{"reviewAndApprove":{"filter":{},"selectionState":[""]},"staff":{"filter":{"queryDisplay":"salesfor"}}}} 1 8/23/2017 5026626 8/23/2017

Resolution

The seed data needed to be corrected in order to have timesheet module in modern ux working and below update query along with other steps is needed. Also please note all the pre requisites needed for a resource to access timesheet is needed. 

  • Stop all the clarity services
  • Back up the table CMN_UI_PERSONALIZATIONS by running below SQL script

create table bkp_CMN_UI_PERSONALIZATIONS as 
select * from CMN_UI_PERSONALIZATIONS

  • Update the table CMN_UI_PERSONALIZATIONS by running below updates

UPDATE CMN_UI_PERSONALIZATIONS
SET USER_ID = 0 
where ID = 5000002 AND COMPONENT  = 'timesheet'

UPDATE CMN_UI_PERSONALIZATIONS
SET personalizations = '{"timesheet":{"reviewAndApprove":{"filter":{},"selectionState":[""]},"staff":{"filter":{}}}}'
where ID = 5000002

  • Start all the clarity services 

Note: Please exercise caution while performing any database update and in case of any doubt please reach out to Broadcom Support