I am having an issue in my system where all transports stall on "EXECUTION OF REPORT AFTER PUT finished with returncode 0". I have noticed on the server when this point is reached, the tp.exe process hits 47% of cpu. It appears that its stuck here, possibly looping on something.
SLOG shows the following:
START imp single X20 20110428152307 JKINARD ip-0A7A557C 20110428151824767 START DD IMPORT X20 H 20110428152307 JKINARD ip-0A7A557C 20110428151824767 STOP DD IMPORT X20 H 20110428152312 JKINARD ip-0A7A557C 20110428151824767 START DD ACTIVATION X20 A 20110428152312 JKINARD ip-0A7A557C 20110428151824767 START tp_getprots X20 J 20110428152312 JKINARD ip-0A7A557C 20110428151824767 STOP tp_getprots X20 J 20110428152318 JKINARD ip-0A7A557C 20110428151824767 STOP DD ACTIVATION X20 A 20110428152318 JKINARD ip-0A7A557C 20110428151824767 INFO TBATG CONVERSION OF X20 N not needed JKINARD ip-0A7A557C 20110428151824767 START MOVE NAMETABS X20 6 20110428152318 JKINARD ip-0A7A557C 20110428151824767 START tp_getprots X20 P 20110428152318 JKINARD ip-0A7A557C 20110428151824767 STOP tp_getprots X20 P 20110428152320 JKINARD ip-0A7A557C 20110428151824767 STOP MOVE NAMETABS X20 6 20110428152320 JKINARD ip-0A7A557C 20110428151824767 START MAIN IMPORT X20 I 20110428152320 JKINARD ip-0A7A557C 20110428151824767 STOP MAIN IMPORT X20 I 20110428152321 JKINARD ip-0A7A557C 20110428151824767 INFO TBATG CREATION OF EN X20 n not needed JKINARD ip-0A7A557C 20110428151824767 START SET VERSION FLAGS X20 V 20110428152321 JKINARD ip-0A7A557C 20110428151824767 START tp_getprots X20 V 20110428152321 JKINARD ip-0A7A557C 20110428151824767 STOP tp_getprots X20 V 20110428152322 JKINARD ip-0A7A557C 20110428151824767 STOP SET VERSION FLAGS X20 V 20110428152322 JKINARD ip-0A7A557C 20110428151824767 START EXECUTION OF REPORTS X20 R 20110428152322 JKINARD ip-0A7A557C 20110428151824767 START tp_getprots X20 R 20110428152322 JKINARD ip-0A7A557C 20110428151824767 STOP tp_getprots X20 R 20110428152428 JKINARD ip-0A7A557C 20110428151824767 STOP EXECUTION OF REPORTS X20 R 20110428152428 JKINARD ip-0A7A557C 20110428151824767 START tp_getprots X20 G 20110428152428 JKINARD ip-0A7A557C 20110428151824767
"X20.LOB" is also stuck in the "tmp" directory. This keeps me from being able to import new transports without first deleting this item out of this directory. Are there any ideas on what might be going on here?
Dear Jeff,
These symptoms usually relates with a "dirty" TMS system.
It is usual after transport failures or system crashes.
I recommend to you to clean the TMS with the following recipe:
- Terminate all tp and/or R3trans process at OS level.
- Empty /usr/sap/trans/tmp directory -> This is important!: Move all contents or delete them.
- From STMS -> Goto -> Import monitor, delete all pending requests.
- Check and empty the tables TRBAT and TRJOB with SM30
- Re-schedule new RDDIMPDP job: log on with DDIC user in client 000 and run report RDDNEWPP.
After these steps your TMS will work correctly.
Of course, try always to use the most recent tools tp & R3trans along with the newest kernel as per note 19466.
Regards,
Rafa
Also check if you have any lock file in /usr/sap/trans/tmp directroy. if any remove it.
Add a comment