Modern UX timesheet continuously loops
Article ID: 231279
Updated On:
Products
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
Feedback
