Hi,
Check if there is any lock on application side. Please run the below queries may me that help. Also check if there is any timeslice rollover going on. In past we face same issue and found timeslice rollover was happening and it put all job on hold. Once it completed other job will run.
How to clear process engine locks on timesheets ---------------------------------------------------------------
1) First determine if any of the timesheets are in an aborted or errored status. These timesheets can be unlocked with low risk. a) Run the following query: 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_ABORTED', 'BPM_PIS_ERROR') b) Run the following to delete all aborted or error based locks. delete from odf_locked_attributes where odf_locked_attributes.id in ( select odf_locked_attributes.id 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_ABORTED', 'BPM_PIS_ERROR') )
2) If no results are found in step 1a or not enough results are found, continue by running the following query: 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 Note: This query shows all timesheets that are locked by the process engine. Some of these timesheets are legitimately locked, but others may be ones that you will want to unlock. 2a) Note down the value of the id field in query 2. For any id's identified in query 2, you should verify by the resource name and time period id that the timesheet is indeed one you want to unlock. 3) Next, you will need to verify the locks for deletion associated with the timesheets from query 2. You can do this by manually specifying the id's obtained in step 2. You will take these id's and insert them into the id list in the following query. 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 odf_locked_attributes.id in (nnnnn,mmmmm,ooooo,ppppp) Note: You will replace nnnnn,mmmmm,ooooo,ppppp, etc. with the id's of the locks gathered in the step 2 query. eg. 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 odf_locked_attributes.id in (5000123,5000124,5000125,5000126,5000127,5000128)
4) Using the list specified in step 2, you will modify the following query to delete the locks. delete from odf_locked_attributes where odf_locked_attributes.id in (nnnnn,mmmmm,ooooo,ppppp) eg. delete from odf_locked_attributes where odf_locked_attributes.id in (5000123,5000124,5000125,5000126,5000127,5000128)
query 5) (Manually Pick the ones that are incorrectly locked) select odf_locked_attributes.id, first_name, last_name, prstart, prstatus, odf_locked_attributes.odf_pk, prtimesheet.prid 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; query 6) delete from odf_locked_attributes where odf_locked_attributes.id in (nnnnn,mmmmm,ooooo,ppppp) nnnnn, etc. will come from query 5 above