Hi all,
processing today suddenly stopped working.
IAM version: 8.1.1
SQL version: Microsoft SQL Server 2016 (SP2-CU16) (KB5000645) - 13.0.5882.1 (X64)
The error in job queue is:
2021-03-17 10:58:08 +03:00 - Serious: Last process step request failed with error: '[810023] Error during execution of statement: exec QBM_PJobQueueLoad N'', 30, -1, 1636943587, N'', N'a18e6a08-5c77-4ef3-8eac-ede678de15fb'-->[810143] Database error 300: detected in (, ) Procedure QBM_PJobQueueLoad, Line 63-->[810143] Database error 300: VIEW SERVER STATE permission was denied on object 'server', database 'master'.'!
2021-03-17 10:58:08 +03:00 - Error occurred in DbRequestQueue.Process (thread: Database Job Requests):
[821002] Error requesting queue '' for database ''.
[810023] Error during execution of statement: exec QBM_PJobQueueLoad N'', 30, -1, 1636943587, N'', N'a18e6a08-5c77-4ef3-8eac-ede678de15fb'
[810143] Database error 300: detected in (, ) Procedure QBM_PJobQueueLoad, Line 63
[810143] Database error 300: VIEW SERVER STATE permission was denied on object 'server', database 'master'.
at VI.JobService.DbProvider.DbRequestQueue.Process(ProviderRequest request)
at VI.JobService.MSSqlJobProvider._MsSqlRequestQueue._HandleGetJobs(IDbSession dbSession, GetJobsProviderRequest request)
---- Start of Inner Exception ----
at VI.JobService.MSSqlJobProvider._MsSqlRequestQueue._HandleGetJobs(IDbSession dbSession, GetJobsProviderRequest request)
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__38.MoveNext()
---- Start of Inner Exception ----
at VI.DB.DataAccess.ReadOnlyDbSession.<SqlExecuteAsync>d__38.MoveNext()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
--- End of stack trace from previous location where exception was thrown ---
at VI.DB.DataAccess.ReadWriteDbSession.<IgnoreBrokenConnectionAsync>d__47`1.MoveNext()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
--- End of stack trace from previous location where exception was thrown ---
at VI.DB.DataAccess.ReadOnlyDbSession.<>c__DisplayClass38_0.<<SqlExecuteAsync>b__0>d.MoveNext()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
--- 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 ----
