Clarity PPM: Time Slicing Job Failing and Not Updating ID 55555 DAILYRESOURCETIMECURVE

book

Article ID: 194113

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

The Time Slicing job is failing to update the time slice DAILYRESOURCETIMECURVE.

The BG logs show 
ERROR 2020-06-27 03:04:40,599 [Dispatch Time Slicing : [email protected] (tenant=clarity)] niku.blobcrack (clarity:clarityuser:sessionid:Time Slicing) Error processing slices 
java.lang.NullPointerException
ERROR 2020-06-27 03:04:40,599 [Dispatch Time Slicing : [email protected] (tenant=clarity)] niku.blobcrack (clarity:clarityuser:sessionid:Time Slicing) Exception during blobcrack process
java.lang.NullPointerException

Cause

This is due to missing/corrupted assignment information related to a timesheet entry.

Resolution

1. Run SQL statement:

SELECT * FROM prtimeentry
WHERE prid IS NULL

2. Review results returned. Based on results,

a. Backup the PRTIMEENTRY table

b. Run delete statement:

delete from prtimeentry 
where prtimesheetid = xxxxx and prassignmentid = yyyyy;

Commit.