Campaign - Missing Revoke Tasks from Unresponded by Certifier

[ejeong]

We have below option enabled to create revoke task for unresponded item

And a lot of revoke tasks are created on campaign expire date. 

Every Campaign, we are finding some missing revoke task

For exmaple, user / account is appearing in campaign report but no task was generated. 

Does anyone expeirence same when running campaign in your envrionment?

[rushikeshvartak · Accepted solution]

Its usually happens when you have database deadlocks . Please create detective control ( analytics report) to handle use cases and completeness 

[ejeong]

Is there a way to clean up deadlock regular based? 

[rushikeshvartak]

deadlocks are database deadlock , this needs to be done by saviynt support team.

how to avoid ?

avoid using custom query job , running report with larger data with less frequency 

[ejeong]

I see... do you do analytics report for campaign to make missed revocation tasks as well? If this is only workaround, we need to build actionable report for that.

[ejeong]

We want to make sure task.source = certification for all..

[rushikeshvartak]

You can create analytics report

[ejeong]

Analytics report.. then task.source will be analytics v2..