Home

Results 1 to 2 of 2

Thread: Process Stuck on Command Queue

  1. #1
    jbroeking NNTP User

    Process Stuck on Command Queue


    I have a process that has been stuck in the Command Queue for almost a
    month now. Is there a way to remove it manually?

    [image: '[image:
    http://s14.postimg.org/wnrzmusgd/7_1..._11_28_AM.jpg]'
    (http://postimg.org/image/wnrzmusgd/)]


    --
    jbroeking
    ------------------------------------------------------------------------
    jbroeking's Profile: https://forums.netiq.com/member.php?userid=5175
    View this thread: https://forums.netiq.com/showthread.php?t=48230


  2. #2
    andy doran NNTP User

    Re: Process Stuck on Command Queue


    If you connect to the CCDB with SQL Query Manager and use this query:-

    SELECT CONVERT(VARBINARY, Status)
    FROM dbo.Queue
    WHERE QueueID = 97

    Then you should see that the status of the item is 0x00000010 (you will
    need to replace the QueueID in the example above with the correct
    QueueID - if you use the UI and double-click the queued command then it
    will tell you what the QueueID is). To change this to "aborted" rather
    than "pending abort" then run this query:-

    UPDATE dbo.Queue
    SET Status = (Status ^0x00000010) | 0x00000020
    WHERE QueueID = 97
    AND Status &0x00000010 !=0

    Again - be sure to use the correct QueueID


    --
    Andy Doran
    Software Engineer Consultant (NetIQ)
    ------------------------------------------------------------------------
    andy_doran's Profile: https://forums.netiq.com/member.php?userid=3937
    View this thread: https://forums.netiq.com/showthread.php?t=48230


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •