Hi Suman,
I have run this query to check the whether its processing or not and my result count is not decreasing from past 12 hours.
Upgrade was done 20 to 30 days back and time slice job ran successfully without any issues after upgrade, now it seems like its stuck for a very long time.
SELECT 'Assignment' Slice_Object,
Count(*) as records, SLICE_STATUS, max(last_updated_date) as last_updated
FROM prassignment WHERE SLICE_STATUS in (1,2,3,4)
GROUP BY SLICE_STATUS
UNION
SELECT 'Allocation' Slice_Object,
Count(*) as records, SLICE_STATUS, max(last_updated_date) as last_updated
FROM prteam WHERE SLICE_STATUS in (1,2,3,4)
GROUP BY SLICE_STATUS
UNION
SELECT 'Availability' Slice_Object,
Count(*) as records, SLICE_STATUS, max(last_updated_date) as last_updated
FROM prj_resources WHERE SLICE_STATUS in (1,2,3,4)
GROUP BY SLICE_STATUS
Union
SELECT 'Timeentries' Slice_Object,
Count(*) as records, SLICE_STATUS, max(prmodtime) as last_updated
FROM prtimeentry
WHERE SLICE_STATUS in(1, 2,3,4)
GROUP BY SLICE_STATUS
Regards
Ritesh