• State Suggested Answer
  • +2 person also asked this people also asked this
  • Replies 15 replies
  • Answers 3 answers
  • Subscribers 94 subscribers
  • Views 18229 views
  • Users 0 members are here
Options
Related

I can't compile in D1IM_v7 due Wait for DBQueue Processor

Gabriel Santos
over 8 years ago

I'm getting a windows message Wait for DBQueue processor and I can't proceed with the compilation.

I checked JobQueue Configuration & some other setting and still the same issue.

Does anyone have any idea how to fix it or what's going on?  Below some screenshots.

Also, I noticed this error in the SQL Server which might be related.

Parents
  • +1 over 8 years ago

    Just, for clarification. You added another CPU to your system and then these Errors occur? Or did you do anything in addition?

    You could use the following SQL statements to remove and reinstall the SQL Agent Jobs:

    -- First check if there are sessions used by the DBProcessor. If so wait for them to be finished
    SELECT spid, PROGRAM_NAME, login_time, hostname
    FROM sys.sysprocesses
    WHERE PROGRAM_NAME LIKE 'SQLAgent%'
    AND dbid = DB_ID()
     
    -- if you need to remove the sql agents for D1IM, exec:
     
    EXEC QBM_PWatchDogPrepare 1
    GO
     
    EXEC QBM_PDBQueuePrepare 1
    GO

    -- To re-initialize the sql agents for D1IM, exec:
     
    EXEC QBM_PWatchDogPrepare 0
    GO
     
    EXEC QBM_PDBQueuePrepare 0, 1
    GO

     

     

Reply
  • +1 over 8 years ago

    Just, for clarification. You added another CPU to your system and then these Errors occur? Or did you do anything in addition?

    You could use the following SQL statements to remove and reinstall the SQL Agent Jobs:

    -- First check if there are sessions used by the DBProcessor. If so wait for them to be finished
    SELECT spid, PROGRAM_NAME, login_time, hostname
    FROM sys.sysprocesses
    WHERE PROGRAM_NAME LIKE 'SQLAgent%'
    AND dbid = DB_ID()
     
    -- if you need to remove the sql agents for D1IM, exec:
     
    EXEC QBM_PWatchDogPrepare 1
    GO
     
    EXEC QBM_PDBQueuePrepare 1
    GO

    -- To re-initialize the sql agents for D1IM, exec:
     
    EXEC QBM_PWatchDogPrepare 0
    GO
     
    EXEC QBM_PDBQueuePrepare 0, 1
    GO

     

     

Children
No Data