After running the Post Timesheet job, you see there is an approved timesheet that is not moving to the Posted status
Looking at the bg-ca.log file, you see the following error:ERROR 2019-10-16 16:04:29,377 [Dispatch pool-5-thread-10 : myPPMuser (tenant=clarity)] xql2.xbl (clarity:myuser:86301970__A09EC2EB-5DE9-4106-B399-27924200EAE4:Post Timesheets) ****POSTTIMESHEET: Couldn't post time entry-->timesheetID=5116383; timeEntryID=6549261; assignmentID=
There is a data integrity issue where an orphan record exists. This issue may be due to a missing row at the PRTASK table where there is an assignment record that does not have a referenced entry on the PRTASK table.
Example:
The timesheet is showing 9 tasks in the UI and at the DB level on the PRASSIGNMENT table, you have 10 rows, 1 being orphan.
Select * from PRTIMEENTRY where prtimesheetid = 5116383
Select * from PRTIMEENTRY where prid = 6549261
Ensure that the data returned on the first query has got a matching record at the PRASSIGNMENT and the PRTASK tables.