Transport (STMS) issue + Hang
From last two days we are facing issue with transport management system. There are two transport sitting in queue and not getting imported. Every time transport process run. It some how remain in the active state and never does anything. we tried to troubleshoot this issue and found that there is 1 record sitting in table trbat which should not be there.
. Also, there may be some other problem which needs to be fixed in order to TMS system work properly.
I have run se16> trbat>enter>execute>it display
Displayed fields: 9 of 10 Fixed columns: 2 List width 0250
TRKORR FUNCTION RETCODE TIMESTMP CLIENT LANGU VARIANT ARGUMENT LOGNAME
HEADER P F 20080908090346 :D:T:S:tmp:F:P080908.C2Q
(Is it neccesary to delete this if yes can u tell me how to delete this?)
I click on table enetry but delete button is inactive
So, Pl. look into it urgently and do the needful as this is causing business issue.
Edited by: mohsin mulani on Oct 2, 2008 2:26 AM
You need to do the following checks and then proceed accordingly:
1. Check the transport logs under transport directory for the above
long running requests (/usr/sap/trans/log or /usr/sap/trans/tmp).
2. Check whether Transport routes are configured properly, using STMS transaction. Also, perform the connection test, tp tool and RFC connections.
3. Execute RSTPTEST program to check the STMS configuration.
To clear the inconsistency and long running tp process , proceed as below.
i. verify whether any tp is running at OS level. kill all the tp
process which is running at the OS level (Ensure there is no transport done during this time).
ii. Move all the files from /usr/sap/trans/tmp to some temporary
iii. Go to STMS -> import overview -> go to ->import monitor and
delete the old entries.
Then review the SAP Note 690449 for any .LOB file that is locking the tp.
Please award points if helpful.