Queue_Not_Empty error in SPAM after restore the DB

[Former Member]

HI all,

i was applying support packages SAPKB70014 and SAPKB70015

but the system stuck and i did DB restore

now the system is working

i tried to update the SPAM to the latest level but i got the following message Queue_Not_Empty

from the OS level

i checked the buffer using this commend :

tp showbuffer QB1 pf=/usr/sap/trans/bin/TP_DOMAIN_DB1.PFL -DSOURCESYSTEMS= TAG=SPAM.

i found the tow package still there

now i want to delete them from the buffer, how can i do that

Note: i tried also

tp delfrombuffer SAPKB70014 QB1 pf=/usr/sap/trans/bin/TP_DOMAIN_DB1.PFL.

no thing happen

please advice

SE..

[Matt_Fraser · Accepted solution]

I too had this issue -- had to restore the database after importing support packages but before confirming the queue -- and none of the suggested function modules -- OCS_RESET_QUEUE or OCS_API_DELETE_QUEUE -- worked for me. Fortunately this wasn't a production system! Obviously, confirming the queue, etc, as one person suggested, isn't going to work with a restored system, as the problem is in the transport buffers which are outside the system. Really, the only way to fix it is to delete all the support packages from the buffer, and the TP method at OS level was looking rather onerous to me, as I was dealing with a very large queue of support packages, an entire support package stack.

However, there's an easier way. You don't need to go to the command line at the OS at all. You can use STMS. Just display the queue for the affected system in STMS, make sure you have no filters on, and you should see a complete list of all the support packs that you now want to reimport after the database restore. You can select the whole block of them and delete them in a single step with Request -> Delete. Afterwards a TP SHOWBUFFER will confirm, if you like, that they are no longer in the queue. Either way, after doing this, the SPAM import, and later the full queue import, work properly without the QUEUE_NOT_EMPTY error.

[shahinmikailov · Accepted solution]

hi Matt,

your suggest resolved my problem.

Thanks,

Shahin

[Former Member · Accepted solution]

Greetings Matt!

Your solution worked!

Thanks a bunch!

J A Cardoso

[Former Member]

Same issue.

Since it was a sandbox system, all that was really needed was to delete the transport buffer file. Quick and easy if you have access to the OS.

Delete the contents of: usr/sap/trans/buffer/<SID> and you will be good to go.

[former_member186895]

Hi,

just login to O.S login and change rename buffer folder as buffer_old

and create one empty new folder as buffer.

Thanks

Ramesh yadav

[former_member273408]

Hi Ramesh ,

Thanks for suggestion . It worked after creating the new folder buffer .

Thanks,

Harsh

[Former Member]

I had same issue, fixed it with the help of Matt Fraser answer.

Thanks Matt Fraser...

Uday Hegde

[former_member227283]

Hi,

In your scenario, you have restore the database, where the database not contain patch information, but the buffer file on OS level contain the information of patch.

Kindly delete the information from buffer using

tp delfrombuffer

command.

Thanks,

Anil Bhandary

[dWrla]

Else, deleting the buffer files if TP refuses to delete the transport requests from a package import works as well and is usually even faster.

[Former Member]

Hello,

Reset the queue from the following path in transaction SPAM.

Extras --> Reset Status --> Queue.

It should solve your problem. Good luck.

Thanks,

Siva Kumar

[Matt_Fraser]

No, that doesn't work in the scenario where you have restored your database in the middle of the queue import. The database status and the transport buffer status are not in sync anymore, and the queue reset function does not work. Believe me, I tried that. You must delete the transports (representing the support packages) from the transport buffer.

[Former Member]

Hi.

I agree with you Matt. You remind me the same issue which I had long back.

Yes, we need to delete the requests from stms_import or we can rename the buffer from /usrs/sap/trans/buffer directory.

Thanks,

Siva Kumar

[Former Member]

Thank you! Your solution worked for me!

[former_member183044]

Hi ,,,

We also had a similar problem in our environment.

We had also given the Basis level upgrade (02 to 03) in SPAM (SAPKB73103). Yesterday evening at 5.00 pm SPDD_SPAU_CHECK phase came. But as of till now it is showing the same phase.

Does this phase takes this much time?

Awaiting ur earliest replies..

Praveen

[Matt_Fraser]

Hi Praveen,

This is an old thread, so there's not much point in asking a new question in the comments here. It's also not the same issue as originally described for this thread. And, I see you've asked it in two other spaces as well. Your best bet is to pick one space and ask it as a new question there.

Regards,

Matt

[Former Member]

Hi Sherif, I had exactly the same problem as you, and I tried the 'OCS_RESET_QUEUE' function module, and that did not work for me either. It told me the OCS queue was still locked. However, I found another function module, 'OCS_API_DELETE_QUEUE' and ran that one, and that fixed my problem. It will give you a scary, doomsday message before you run it, but if your DB really is consistent, you should be OK. Good luck, and kind regards,

Matthew

[Former Member]

Hi,

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.

http://help.sap.com/saphelp_nw04/helpdata/en/7e/c6c2ad98a711d2b429006094b9ea64/content.htm

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCUPGOCSSPAM/BCUPGOCSSPAM.pdf

you probably forgot to confirm last SPAM or SAINT application.

go into SPAM and choose CONFIRM

go into SAINT, and choose FINISH

OR

It appears that already some support pack update is in process. So check tcode SPAM or SAINT and see whether anything is running.If it is running wait for it or see whether it is asking for confirmation.. then u need to confirm the queue.

Also you can go to tcode SPAM and see display/define tab and see whether anything is available over there..if you are sure u dont want to import the ones in the queue,then just delete the queue using trash icon over there..

Regards,

Srini Nookala

[Former Member]

Dear All,

as i said before i was applying the patches for SAP Basis component and the system stuck.

so i go for restore DB option from old backup .

now the system is working fine and in the SPAM nothing in the queue.

now i want to update the SPAM to latest version but it gives me that message the Queue_Not_Empty in CHECK_REQUIREMENTS phase

i restarted the system nothing happen.

My issue here how to delete the buffer.

thanks

SE

[Former Member]

hi,

in Se37,Use the function module OCS_RESET_QUEUE --- >execute --->IV_TOOL=SPAM, IV_FORCE=X

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

Please make sure thatthere is no TP process

or R3trans process running in the system at Operating system level.

If any process exist, Please kill the process.

As per my knowledge to delete SP's from buffer only one command at OS level is

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

Edited by: Imran Mulani on Aug 24, 2008 2:39 PM

[ganesh_s7]

Restart your Serverbox. That should solve your problem.

Let me know... if that solvs the problem

[Former Member]

there is one function module OCS_RESET_QUEUE ( SE37) for reset queue