Wednesday 27 June, 2007

Transport is running & running.....(STMS)

Your trasport request keeps on running and running......

Take a look at tables TMSTLOCKR and TMSTLOCKP. These contain list of transports currently running. These do not always clear when a transport has completed.
If they have an entry for your change request then it will need to be removed.

I usually do this at the database level with a SQL statement.

If this does not resolve your problem check that the usr/sap/trans/tmp directory
for a .lob file. If one exists delete this and then rerun the last transport.

SQL Query must be something like this:

delete from XYZ.TMSTLOCKR where TRKORR = 'XXXYYYY'

XXXYYYY - Request Number

XYZ - Owner of the table