How to re-trigger events stuck due to disabled provisioning task
In our provisioning queue we have some amount of stuck events caused by accidental disabling of provisioning tasks to execute. When the tasks are enabled again now those events sitting in the queue do not want to be processed anymore by IDM.
Now in the queue we have the following tasks:
- Task group A ("Expanded OK" in MXP_PROVISION, ProvStatus = 1 - "Task not enabled for provisioning" in MXP_AUDIT table)
- Sub-task B ("Expanded OK" in MXP_PROVISION)
- Sub-task C ("Waiting" in MXP_PROVISION)
- Sub-task D ("Waiting" in MXP_PROVISION)
Tasks B,C,D had been temporarily disabled in Identity Center. But now all they are enabled again. And now IDM does not want to process the previously expanded events already sitting in the queue. Perhaps, it's because the root task group is already marked with status 1 "Task not enabled for provisioning" in the audit table.
So, how to re-trigger the stuck events sitting in the queue and force the WAITING tasks to be processed ? By the way, all of them are just MODIFY events, not assigments (links/assigments are not involved here).
Thank you for any hints,
Siarhei Pisarenka replied
Finally it's resolved by my own. I used the following SQL to re-trigger execution of the task group:
|-- delete already expanded sub-tasks from the queue (here the IDs of sub-tasks are specified)|
delete from mxp_provision where MSKey = @MSKey and AuditRef = @AuditID and ActionID in (1002143, 1002148, 1002153, 1002137)
-- re-run the task group again (set it as ready-to-run) (here the ID of the task group is specified)
update mxp_provision set State = 2 where MSKey = @MSKey and AuditRef = @AuditID and ActionID = 1002136