on 08-23-2008 10:58 PM
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..
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Matt Fraser...
Uday Hegde
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
Restart your Serverbox. That should solve your problem.
Let me know... if that solvs the problem
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.