Skip to Content
avatar image
Former Member

Queue_Not_Empty error in SPAM after restore the DB

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..

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • Best Answer
    Nov 09, 2011 at 09:41 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 20, 2012 at 04:09 PM
    I had same issue, fixed it with the help of Matt Fraser answer.

    Thanks Matt Fraser...

    Uday Hegde

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 30, 2012 at 04:21 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 24, 2008 at 09:16 AM

    Restart your Serverbox. That should solve your problem.

    Let me know... if that solvs the problem

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 24, 2008 at 11:29 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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

  • avatar image
    Former Member
    Mar 03, 2010 at 10:28 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 09, 2011 at 09:53 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Nov 10, 2011 at 05:45 AM

    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

    Add comment
    10|10000 characters needed characters exceeded