Run the following query to find out if any timesheets have been locked by a process. Check the state of the Process Engine and make sure that all processes have been processed. If there are any results from this query and you have checked to ensure the BPM process is not moving forward or 'stuck' you may need assistance from the Clarity Support Team to release the lock on these Timesheets.
Capture Screenshots of the Process error that has caused the Timesheet to remain locked
Capture Screenshots of the Process Engines page showing that the Process Engine is running fine
On Premise Customers: Provide a copy of the full bg-ca.log file
On Premise Customers: Provide the output of the following query into a Microsoft Excel spreadsheet with header rows :
select odf_locked_attributes.id, first_name, last_name, prstart, prstatus,
odf_locked_attributes.odf_pk, prtimesheet.prid timesheet
from odf_locked_attributes, prtimesheet, prtimeperiod, srm_resources
where object_code = 'timesheet'
and attribute_code = 'prstatus'
and odf_locked_attributes.odf_pk = prtimesheet.prid
and prtimesheet.prtimeperiodid = prtimeperiod.prid
and srm_resources.id = prtimesheet.prresourceid
To find if there are any locked attributes for a specific timesheet, add the following to the end of the above query:
and odf_locked_attributes.odf_pk = <internal id of the timesheet>