Run the following query to find out if any timesheets have been locked by a process. Check the state of the BPM 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 CA Technical Support 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, status_code, object_type_code
from odf_locked_attributes, prtimesheet, prtimeperiod, srm_resources, bpm_run_objects, bpm_run_processes
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
and odf_locked_attributes.odf_pk = bpm_run_objects.object_id
and bpm_run_objects.table_name = 'BPM_RUN_PROCESSES'
and bpm_run_objects.object_id = odf_locked_attributes.odf_pk
and odf_locked_attributes.object_code = bpm_run_objects.object_type_code
and bpm_run_objects.pk_id = bpm_run_processes.id
and status_code in ('BPM_PIS_ABORTING', 'BPM_PIS_ABORTED', 'BPM_PIS_ERROR')