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

Question

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.

Markus Weiss-Ehlers · Answer

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

dbk · Answer

I have run into this issue after increasing the number of CPUs. "Wait for DB Queue processor" 
 In SSMS I see the following... 
 
 Note: "agent not exists (queue prepare missing): QBM_PDBQueueProcess009" 
 As a workaround, I lowered the CPU back down to the previous setting. I have heard there may be a method to force recalculation of agents to match the added queue based on current CPU count.

carolsmith30111984 · Answer

It is just a bit of clarity that if you have connected any
other Central Processing Unit to your working system and what are
the Errors in the SQL Server you are getting.
According to my knowledge if more CPU is added to the database server,
Then this sort of error occurs.facebook
I am providing you the basic steps, hope this might help.
In JobQueueInfo -> Go toMenu -> Select Help -> Emergency Stop -> Stop DBQueue processing

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

Top Replies