Issue
The system has millions of records with a next action date in the past. Most of the records appear to be (ASYNC: Handle User-Activation CT Tracking). This backup is causing a delay with our other jobs.
Similar to KB0789201/PRB1374288 except the name has an ending 'g' '
ASYNC: Handle User-Activation CT Tracking <> ASYNC: Handle User-Activation CT Trackin
Release
Madrid P7a
Cause
- The high volume of ASYNC: Handle User-Activation CT Tracking jobs comes from the Business Rule Handle User-Activation CT Tracking which comes from this functionality: Using Subscription Management to Monitor Usage
- The Business Rule Handle User-Activation CT Tracking activates when any update is made on the sys_user table
- Imports that are making a lot of updates to the sys_user table will cause this issue.
- This is related to PRB1374288 but with a slightly different symptom.
Resolution
You can delete all of the pending ASYNC: Handle User-Activation CT Tracking jobs so it does not delay your other jobs from running
For preventive measure, you can do either of the following:
- Disable business rules to run when running the imports to the sys_user table
- OR
- Add a condition on the business rule Handle User-Activation CT Tracking to not execute the update comes from an import (maybe by the user who is making the update to sys_user)
- OR
- Disable the business rule Handle User-Activation CT Tracking if you're not using it.