Bulk Operations Cause JobQueue Cleanup to Stop Working (4383774)

When performing large bulk operations (for example, assigning roles or account definitions to many thousands of users at once), the system can create too many Dynamic Group recalculations at the same time.

This leads to the following problems:

• Errors when updating group membership information
• JobQueue becomes full of successfully completed jobs that are not removed
• The queue appears to clear briefly then fills up again
• DBqueue processing gets stuck in a loop
• Restarting the database agent does not fix the issue

During very large updates, multiple processes try to add the same group membership record at the exact same time. The system is not fully prepared to handle this high volume safely, which causes errors and prevents normal cleanup of completed jobs.

Waiting for a fix in a future release of Identity Manager. If impacted by this issue, please contact Support for a hotfix for Defect number 722571 

How to Avoid This Issue To reduce the risk of too many Dynamic Group recalculations happening at once, follow the best practices in this article: Preventing DBQueue Flooding During Mass Imports (4383019) 

If the JobQueue becomes stuck, run the following command in SQL Server Management Studio (you can run it multiple times if needed):

EXEC dbo.QBM_PWorkJobQueueDelete;