When the timeslicing job fails it is noted that only the DAILYRESOURCETIMECURVE slice not getting updated and the bg log catches the following exception:
Dispatch Time Slicing : [email protected] (tenant=clarity)] niku.blobcrack (clarity:casupport:xxxx:Time Slicing) Exception during blobcrack processjava.lang.NullPointerException
The cause of the issue is internal defect : CASUP-589.
Release : 15.7.1
Component : CLARITY PPM TIME TRACKING
Faulty null PRIDs found in the PRTIMEENTRY table is the primary cause of the issue. These faulty time entry id's in the system is noticed to have both prid and pruid as NULL. As per investigations it is suspected that the same would have been populated by an external interface or code, as Clarity PPM always generates a PRID/PRUID.
SQL used for listing faulty PRIDs:-
select * from prtimeentry where prid is null order by incident_id;
The SQL delete statements to remove the faulty PRIDS would be part of the troubleshooting course taken as per defect CASUP-589. If the indications of the issue is same as described here then please contact support for further steps.
The source of the faulty PRIDS still remains a mystery and will be investigated during future occurrences of he issue. If the same was submitted via the timesheet UI then the IDs should been generated and not logged as NULL. It is generally advised to not update the prtimeentry table directly or through interfaces.