Clean TP BUFFER

[Former Member]

Hi all

I need to remove entries from TP BUFFER.

Our SPAM Patch got stuck some where. I removed all the entries from PAT01, PAT02, PAT03, PAT10, TRBAT & TRJOB tables but still we are facing same problem.

I got QUEUE_NOT_EMPTY error message.

Here is the solution:

CHECK_REQUIREMENTS

In this step, various requirements for the import of the Support Package are checked.

The following messages explain why this step may be terminated:

QUEUE_NOT_EMPTY: There are incompletely processed OCS requests in the tp buffer.

Use the following tp command to display these requests:

tp SHOWBUFFER <SID> -D SOURCESYSTEMS= TAG=SPAM

You can continue processing the queue as soon as these requests have been processed

completely, or deleted from the tp buffer.

I GOT MISSING PARAMETER ERROR WHILE I TRIED THIS COMMAND,

IS SOURCESTSEMS = HOST NAME?

PLZ LEMME KNOW THE RIGHT COMMAND....

[Former Member]

Hi Vyas,

You need to clean all the buffer you can follow below steps

1. rename buffer

if it isECC6 and OS is UNIX use

cd /usr/sap/trans/ECC60/buffer

mv <buffer> <new name>

if it is below go to buffer directory

mv <buffer> <new name>

2. Create new buffer

touch <SID>

chmod 664 <SID>

chown <sad>adm:sapsys <SID>

Note:

<SID> SID of the system capital letters

<sid> should be small letters

Regards,

Krishna reddy

[former_member256928]

thanks a lots

[former_member603052]

Hi Vyas,

Login to 000 client and execute Tcode SPAM---beside the queue you will find Display/Define Button.

Click on it...select the pack and delete

Regards,

Kalyan

[former_member185031]

Check the objects in STMS Queue and delete the support patch from STMS Queue

Regards,

Subhash

[Former Member]

Thank you, this solved my issue.

STMS, filter by SAP user, delete the old upgrade entries from the queue.

[Former Member]

Another tip to clean the transport entries if in case you have something in STMS saying it is still running.

Make sure the tp process at OD level is killed and then delete the entries for the transport in the folliwng tables

TRBAT, TRJOB TPSTAT, TMSTLOCKR, TMSTLOCKP

Pravin

[Former Member]

Hello,

Please try this command: tp showbuffer <SID> pf=<location_of_profile> tag=SPAM

and let me know if it works

Rohit