patch got stoped in import queue status

[Former Member]

sql server 2005

how can i connect to database in sql server 2005

can any one pls tell me how can i delete from database level in pat03,pat01 tables

sid:   dev

snr    00

[former_member182034 · Accepted solution]

hi ambati,

now you need to reset the SPAM Queue to match the TMS buffers.

and You can reset the queue via

SPAM = Extras --> Reset Status --> Queue

or

To remove entries from the internal SPAM Queue,

You have to use Function Module OCS_RESET_QUEUE via SE37 with following parameters:

IV_TOOL=SPAM, IV_FORCE=X.

Note:

1. Deleted all the files from \usr\sap\trans\tmp

2. Please make sure that there is no TP process is running when you run above function module.

if you want to delete the entries on OS level then you can delete via following sql command.

tp delfrombuffer SAPKXYZ <SID> pf=/usr/sap/trans/bin/TP_DOMAIN_<SID>.PFL

Regards,

[Former Member]

Thank you jamil........for your response it worked for me