On-Premise - Enable 16.4.1 Administrative Maintenance jobs

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Overview

Two new administrative maintenance jobs are introduced in Clarity Release 16.4.1. 

• Database Optimization Job
• Focuses on core database cleanup and maintenance activities to clean up orphaned records for captions, instance rights and page instances.
• System Maintenance Job
• Handles specific system-level maintenance tasks to clean up records for the PPM Broker, Data Warehouse records and Error Process Logs.
• Built-in safeguards
• Both maintenance jobs introduce performance-based safeguards by validating parameter inputs against default maximum limits. Any input exceeding these thresholds is automatically overwritten by the default value—as detailed in the job’s WARNING parameter—to ensure that high-volume cleanups do not negatively impact system resources. Because the job will only process data up to this defined safety limit in a single execution, you may run the job again to process any remaining data as needed.

Environment

Clarity 16.4.1+

Resolution

After Upgrade

• For SaaS Customers: 
• No actions required after upgrading  
• The internal toggle has been enabled for all SaaS environments
• the 'Database Optimization' job has been set up with a recurring scheduled instance - Weekly on Sunday at 3:00 AM (server time) 
• The 'System Maintenance' job has not been scheduled
• Recommendation: Review and schedule once per week during non-peak time or weekend
• For On-Premise Customers:
• Review both jobs to determine parameters configuration and recurring schedule.
• Recommendation: Schedule to run once per week during non-peak time or weekend 
• If the INTERNAL toggle is not already enabled (from a prior release), it must be enabled for the jobs to process data
• Otherwise both jobs will not process data and have one of the following Job Log Messages:
• Feature toggle for the Database Optimization job is not enabled.
• Feature toggle for the System Maintenance job is not enabled. 
• Take Action: 
• Ask your System Administrator to perform the following command-line statement to enable the feature. This will allow both jobs to process the data. 
• admin toggle-feature NMC_DB_MAINTENANCE_JOB 1
  
  Note: The admin toggle-feature command generally requires a restart of all Clarity services (including the Background/Job service) to take effect. If not message like "Feature toggle for the Database Optimization job is not enabled" is found during the job execution.