Post Timesheet Job Not Completing, Shows Processing

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

The Post Timesheets job is stuck in the 'Prcoessing' state and will not complete.

 

Cause

One or more of the following exist:

1. BG log file shows:

***POSTTIMESHEET: Error posting timesheet - unknown error-->timesheetID=XXXXXXX
java.lang.OutOfMemoryError: Java heap space

2. There are jobs stuck 'Waiting' on the Post Timesheets job.

Resolution

Resolution based on cause/symptom:

1. Check if there is JVM parameter is set correctly.

2. Cancel and delete the current Post Timesheets job instance that is stuck processing.
This will enable the other jobs to progress.
Reschedule the Post Timesheets job.

Additional Information

Run below query to see how many timesheets are waiting to be posted.

select count(1)
from PRTIMESHEET
where prstatus = 3 --approved