Absent Member.. rchundi Absent Member..
Absent Member..

(PPM) Support Tip: Error while opening a resource's time sheet

A user is unable to open the time sheet and encountering an error. This happens only to one time sheet and time sheet is in an Unsubmitted status.

When the issue happens, the following error message is found in the server log.

Caused by: java.lang.NullPointerException

               at com.mercury.itg.tm.impl.TimeSheetImpl.isValidLine(TimeSheetImpl.java:1226)

               at com.mercury.itg.tm.impl.TimeSheetImpl.reEvaluateApprovers(TimeSheetImpl.java:1212)

               at com.mercury.itg.tm.impl.TimeSheetImpl.reEvaluateApprovers(TimeSheetImpl.java:1199)

               at com.mercury.itg.tm.web.EditTimeSheetAction$1.run(EditTimeSheetAction.java:168)


Check the time sheet line data of the problematic time sheet.

Run the following SQL in the PPM schema.

select t.* from tm_time_sheet_lines t where t.time_sheet_id = < replace the problematic time sheet id> order by T.TIME_SHEET_LINE_SEQ

Please check the data.

The TIME_SHEET_LINE_SEQ for a time sheet should start with 0 and be consecutive, like 0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26....

If the TIME_SHEET_LINE_SEQ  is not consecutive in user's time sheet. manually update the TIME_SHEET_LINE_SEQ  to make it to be consecutive.

** Note **: It is always recommended to try the solution in a non production instance before updating in Production instance. Also, take a back up of the data before doing any direct updates in the database.


Labels (1)
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.