Restarting a hanging transport

[Former Member]

Restarting a hanging transport

I have already read that the hanging transport can be restarted by deleting all entries from tables TRBAT and TRJOB.

Use SE16 to delete the entries or use sqlplus (delete * from sapr3.TRBAT and delete * from sapr3.TRBAT).

a) How can I proceed when I use SAP DB?

b) What is the exact actions to delete the entries with tcode SE16?

Thank you very much!

Regards

Thom

[former_member229109]

Hello Thom,

-> I recommend you to create the ticket to the component BC-CTS

to check why the transport was hanging.

-> Please see hints in the SAP Note No. 556941 < 5. An import seems to hang. >.

If the import is hanging, then you can check the tables TRBAT and TRJOB via SE16 or SM30 to see if there are old entries there. Do you have the old entries or not ? What are you going to delete?

You need to find the reason of the hanging transport first before to do further action.

-> Please check the activities in the database too.

For example, run 'x_cons <DB-SID> show active' on the database server. Do you have DB_FULL or LOG_FULL issue in database?

-> "Restarting a hanging transport

I have already read that the hanging transport can be restarted by deleting all entries from tables TRBAT and TRJOB."

Where did you read it? Could you please give the reference to the SAP note/document.

Did you already kill the 'tp' process at OS level & would like to clean the entries left from the aborted process?

Thank you and best regards, Natalia Khlopina

[Former Member]

Thom,

With SE16, you are using the old 'debug and repalce' method to remove the entries. In short, you goto the table with SE16, display the entries in the table, then use the '/h' switch to enter debug mode when you goto detail view on a particular row - if you step through there is a case statement where you change the variable from 'display' to 'delete'. You will know when you see it what I am talking about.

If you use the SQL Studio (you can download this for free) and your SQL is really good (you really gotta know what you are doing here or you can cause some interesting problems) you can use this tool to do the 'delete' SQL direct to the system. You can install this on your laptop/desktop or on the server if you are running windows, and then connect to the Db.

Hope that this answers your questions - if it does, please set this thread to answered.

[lbreddemann]

Hi there,

just to mention it: doing such modifications without the supervision of SAP support may render your system unsupported.

Better check if SAP notes like

SAP Note 71353 Transports hang during background steps

help you.

Otherwise: open a support message and have the support collegues explain the necessary actions.

KR Lars