We are in the midst of upgrading the SAP support package and part of the requirement is to suspend the batch jobs. During the report BTCTRNS1 execution, below error prompt out,
All jobs currently locked (repeat report)
Resolution
Basically, in our case, we didn’t do anything, we just re-run the report after 5 minutes. The report was successfully executed.
But, in case you are still getting the same error message, please refer to SAP Note 2423000 – “All jobs currently locked (repeat report)” error of BTCTRNS1 report.
The information below is taken from the above SAP Note.
TBTCO is the main table of job. Each batch job has exactly one entry in this table.
if you want to suspend jobs by running BTCTRNS1 program, it needs to get lock of TBTCO table at first.
“All jobs currently locked (repeat report)” error occurs when executing BTCTRNS1 program because entire table TBTCO is locked.
The resolution steps,
You should check lock entries on TBTCO table in SM12. Normally, the lock entry on TBTCO table caused by following:
SM65 transaction execution
Since SM65 transaction execution would lock TBTCO table on lower release system(which lower than SAP Note 1549293 ), please check if somebody is executing SM65 transaction to perform inconsistency check.
Please be aware that there is a sap standard job named SAP_BTC_TABLE_CONSISTENCY_CHECK(RSBTCCNS) which do the same job as SM65. Please also check if this job is running.
SAP_REORG_JOBS(RSBTCDEL2) job
Please check if the job SAP_REORG_JOBS(RSBTCDEL2) is running since RSBTCDEL2 would lock TBTCO table in some special situation. SAP Note 1396995 – RSBTCDEL2 locks all of table TBTCO
