More CPUs have been added to the database server, and the check for count of CPUs against existing SQL Server Agent Jobs is failing.
Identity Manager Front-ends display the message "Wait for DBQueue processor" and the "QBM_PDBQueueProcess_Main" SQL agent job is failing.
To solve this issue re-create the SQL Server Agent Jobs for the Watchdog, Main Agent and the individual slots.
SELECT spid, program_name, login_time, hostname
FROM sys.sysprocesses
WHERE program_name LIKE 'SQLAgent%'
AND dbid = DB_ID()
-- Shutdown DBQueue and processors
EXEC QBM_PWatchDogPrepare 1
GO
EXEC QBM_PDBQueuePrepare 1
GO
-- Cleanup DBQueueCurrent
EXEC QBM_PDBQueueCurrentRestore 0, @IgnoreGeneration = 1
GO
-- Restore the agents
EXEC QBM_PDBQueuePrepare 0, 1
GO
EXEC QBM_PWatchDogPrepare
GO
© 2021 One Identity LLC. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy