Notifications

90 views

Description

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 or Environment

Madrid P7a

Cause

  1. 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
  2. The Business Rule Handle User-Activation CT Tracking activates when any update is made on the sys_user table
  3. Imports that are making a lot of updates to the sys_user table will cause this issue.
  4. 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:

  1. Disable business rules to run when running the imports to the sys_user table
    • OR
  2. 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
  3. Disable the business rule Handle User-Activation CT Tracking if you're not using it.

Article Information

Last Updated:2020-07-22 03:16:18
Published:2020-07-22