Return
-
Title
Error in Job Server Log: "Database error 50000: Processing is disabled (this queue is switched off)" -
Description
Error in Job Server Log:
"[821002] Error requesting queue '\[QUEUE NAME[] for database '[DATABASE NAME].[810023] Error during execution of statement: exec QBM_PJobQueueLoad N'\[QUEUE NAME]', 90, -1, 0, N'', N'a2d4090c-98cc-4f57-93ec-2e0a9dbb05ab'[810143] Database error 50000: detected in (SRV=[DATABASE NAME] Procedure QBM_PJobQueueLoad, Line 136[810143] Database error 50000: Processing is disabled (this queue is switched off).at VI.JobService.DbProvider.DbRequestQueue.Process(DbRequest request)at VI.JobService.DbProvider.DbRequestGetJobs.Process(IDbSession dbSession, RequestDispatcher dispatcher)---- Start of Inner Exception ----at VI.JobService.DbProvider.DbRequestGetJobs.Process(IDbSession dbSession, RequestDispatcher dispatcher)at VI.Base.SyncActions.Do[T](Func`1 function)at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)---- Start of Inner Exception ----at VI.DB.DataAccess.ReadOnlyDbSession.<SqlExecuteAsync>d__36.MoveNext()---- Start of Inner Exception ----at VI.DB.DataAccess.ReadOnlyDbSession.<SqlExecuteAsync>d__36.MoveNext()at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)--- End of stack trace from previous location where exception was thrown ---at VI.DB.DataAccess.ReadWriteDbSession.<IgnoreBrokenConnectionAsync>d__42`1.MoveNext()at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)--- End of stack trace from previous location where exception was thrown ---at VI.DB.DataAccess.ReadOnlyDbSession.<>c__DisplayClass36_0.<<SqlExecuteAsync>b__0>d.MoveNext()at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)--- End of stack trace from previous location where exception was thrown ---at VI.DB.DataAccess.SafeDbCommand.<_CheckedAsync>d__40`1.MoveNext()---- Start of Inner Exception ----" -
Cause
"IsJobServiceDisabled" flag set to True in table "QBMServer" as per the procedure being called, QBM_PJobQueueLoad:
"if @IsQueueDisabled = 1 begin select@RaiseCondition = '#LDS#Processing is disabled (this queue is switched off)." -
Resolution
Set "IsJobServiceDisabled" flag set to False in table QBMServer for the queue being referenced.
This can be set at the table level using Object Browser, for example, or from the Extended tab for the Job Server in Designer.