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
Release : 16.0.0
Component : CLARITY TIME MANAGEMENT
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 |
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.
create table bkp_CMN_UI_PERSONALIZATIONS as
select * from CMN_UI_PERSONALIZATIONS
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
Note: Please exercise caution while performing any database update and in case of any doubt please reach out to Broadcom Support