How to re-create failed tasks

[mblakey]

Here's my use case:

I have a role with several entitlements over more than one connection. One of the connections was unavailable for 2 weeks, and therefore tasks created for it eventually failed after 10 retries. Now that the connection is back online, how do I re-create these failed tasks?

I've tried running a retrofitjob pointed at the role, but this doesn't seem to work. I've also used the Repair Role to User Mappings button, but this doesn't seem to do the trick either. Am I missing something?

Mark

[dgandhi]

Bring that task back to pending state. Once it is pending state, next time when provisioning job runs , it will pick the task and assign the access.

[dgandhi]

Sample query:

update arstasks set status=1 where taskkey='597374';

where 597374 is the task id which you want to reprocess.

[rushikeshvartak · Accepted solution]

Open task again using custom Query job

update arstasks set status=1,PROVISIONINGTRIES=0,PROVISIONINGCOMMENTS=null where taskkey=4020583 limit 1;

[mblakey]

Thanks guys, this solution worked perfectly.

[naveenss]

From an audit standpoint, avoid using custom query jobs to reopen tasks as much as possible. Instead use actionable analytics control to do the same.