Automatic Transport jobs keeps running

[Former Member]

Hi,

I have scheduled an automatic transport job:

TMS_0000000001TMS_TP_IMPORT in BIQ to run every 30 minutes. We want to

be able to transports every 30 minutes in BIQ. For some reason it keeps

running. I tried to Shop it and I am unable to stop it. Every time I

try To stop it, I get the below error message: u201CError Locking table

TBTCOu201D. When I try to delete the job I get the message u201CFailed

To lock job u201CTMS_0000000001TMS_TP_IMPORTu201D. Please advise as i can

no longer do any more transports.

[Former Member · Accepted solution]

Hi,

Did you try killing the same at OS level. Check at OS level how many tp process are running. If more than one are running then kill all of them at OS level. After that delete the entires from TRBAT and TRJOB tables. Also, please refer the below link if it can help.

http://www.basis2048.com/rsbtcdel2-locks-all-of-table-tbtco-1182.htm

Regards,

Sharath

[Former Member]

In SM37 how many jobs are active?

also can you please check in SAP, tcode stms_import --> goto --> import monitor --> goto --> display TP log

[Former Member]

If you are not able to cancel the job ,terminate the associated WP fro that job.

Regards,

Srinivas Chapa.