返回
-
标题
DBQueue is not processing after a SQL migration -
说明
The DBQueue is not processing any items, trace level job service logs shows the same error over and over:
Cannot release the application lock (Database Principal: 'public', Resource: 'QBM_PWorkDBQueueMain') because it is not currently held.
Type=Restart
QBM_PWorkDBQueueMain encountered an error. Restarting...Please note: This will only show for the job server that holds the database agent plugin.
-
原因
Missing permissions in SQL.
-
解决办法
Ensure that the account being used for the SQL connection has the following permission: VIEW SERVER PERFORMANCE STATE