Scheduled Refresh Resource Directory jobs cause high load and executions on CMN_SCH_JOBS

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Post upgrade of Clarity Version 16.2.2 onwards there was higher execution of the query pertaining to table CMN_SCH_JOBS due to Job The Refresh Resource Directory jobs which is required to populate data for feature Resource Directory (Beta)

 

STEPS TO REPRODUCE:

1. Start on 16.2.1 or similar earlier release
2. Upgrade to 16.2.2+, i.e.16.3.1 and do not have Resource Directory Feature enabled
3. Monitor the SQL load on the database and executions (transaction log in MSSQL)

Expected Results : There shouldn't be any higher execution pertaining to table CMN_SCH_JOB

Actual Results: The higher execution is seen because out of box The Refresh Resource Directory job are in Scheduled state even for customers who haven't enable Resource Directory (Beta) feature via feature toggle causing the job to poll database frequently 

Environment

Clarity 16.2.x, 16.3.x

Cause

DE167314

Resolution

The resolution to this is provided in 16.3.2, 16.3.1.1 (16.3.1 Patch 1), and 16.2.3.3 (16.2.3 Patch 3) 

Workaround:

• Option 1 - Cancel and delete the job from Scheduled 
  • This is possible on 16.3.0 and lower releases

1. 1. Connect to Clarity Classic - Home - Reports and jobs 
   2. In Scheduled Jobs filter for Job Type: Refresh Resource Directory or Job: REFRESH_RESOURCE_DIRECTORY 
   3. Note if you have jobs there and what the status is
   4. Cancel and delete the job(s) from UI

• Option 2 - Enable the Feature temporarily

1. 1. Go in MUX Administration - Feature Toggles - enable "Resource Directory and Relationship Explorer"
   2. This will allow you to see the jobs in Scheduled and they will complete
   3. You can now disable the feature again - once you confirmed the jobs have completed. 

Additional Information

Note: For Broadcom SaaS customers not utilizing the Resource Directory (Beta) feature, the "Refresh Resource Directory" job, which was provided out-of-the-box as scheduled in version 16.3.0, has been set to a "Paused" status due to the defect mentioned above.

For customers actively using the Resource Directory (Beta) feature, there is no change in functionality or the job's status.