Sunday, October 2, 2016

STMS : If SAP transport request is hang

SAP transport request is hang.

Check the below snotes which will help you to fix the issue

Note 71353 - Transports hang during background steps
NOTE 12746,818065, 302859, 556941, 556946, 71353, 49242, 323726, 56311, 24800, 486991, 506771, 138200,26966, 449270.
Note 1114801 - STMS_QA: Error UNKNOWS_SYSTEM with authorization in QA
Note 1298927 - SYSTEM_ACCESS_DENIED when creating/deleting TMS domain link
Note 642464 - Profile file for the program sapevt
Note 821875 - Security settings in the message server
Note 802172 - sapevt (Version 4): Release-independent version

1.Verify that there are no errors in system log.

2. - If Problems with job RDDIMPDP
Execute SE38 > Run program RDDNEWPP > Choose Normal priority. This will schedule new RDDIMPDP job that is responsible for pushing transport requests in your system.

3.Execute transaction STMS

a) Select Import Overview
b) select SID
c) From menu > Go To > System Log
d) Correct if any issues in log.

4. \usr\sap\trans\tmp\SID.LOB is already in use

(22720), I'm waiting 2 sec (20100322091720). My name: pid 10128 on
SERVER (SIDadm)

a) Backup and delete the file  usr\sap\trans\tmp\SID.LOB'. Add the transport again and perform import.

b) Cannot find \usr\sap\trans\log\SLOGXXX.SID
Make sure that file exists. If not, copy the most recent SLOG (example SLOGXX01) and rename it to SLOGXX02.SID. Check again the system log if the issue persist.



Steps to clear the transport list to make sure that transports push successfully. This should be aligned with customer.

1. Clear the transport list and redo the transport
a) Execute transaction STMS
b) Import overview -> Goto -> Import monitor >
c) 'Monitor' -> right click on transport -> delete entry
d) Redo the transport action. Proceed to next step if not solved.

2. Clear the transport tables
a) Make sure that there are no stuck transports in your transport tables.
b) Check and delete entries (using transaction SM30) any entries found in the following tables:

TRJOB
TRBAT

b.1 To do this execute SM30
b.2 Enter 'TRBAT' in Table/View.
b.3 Click on Display
b.4 Verify that No transport number or HEADER exists.

or else you can truncate from oracle using below commands.

truncate table sapecc.tpstat
truncaate table sapecc.trjob


Also you can delete the entries from tables TMSTLOCKR and TMSTLOCKP.

import the transport request.

If this does not solve the problem. You have the option to stop all transport from OS level.

3 Kill if running any tp process at OS level
and import the TR agin.


To save transport resources:

1. It is SAP's recommendation that imports to be done asynchrounously rather than synchronously. By doing this you will be conserving system Resources.
   import > Execution tab > Select 'Asynchrounously' > Confirm import

2 comments: