When you encounter issues with the CMDB or CSDM Data Foundation Dashboard metrics not executing properly or running too slowly, you can follow these steps to identify and resolve problems:

Viewing Execution Statistics

1. Navigate to System Definition > Tables
2. Search for and open the sn_getwell_metric_execution_stats table
3. Look for recent entries related to your problematic metric
4. Check the execution_status field:
   
   • Started: Job is currently running
     
   • Completed: Job completed successfully
     
   • Exceeded: Job exceeded its runtime threshold

Identifying Problematic Metrics

• Filter by execution_status = Exceeded to see all metrics that have exceeded their thresholds
• Check the run_time field to see how long each execution took
• Compare against the metric's runtime_threshold to understand the severity of the issue

Check Activation Audit History

1. Navigate to System Definition > Tables
2. Search for and open the sn_getwell_metric_activation_audit table
3. Look for entries related to your metric
4. Pay attention to:
   
   • action_type: Manual for manual deactivation, Automatical for automatic deactivation
     
   • audit_info: Contains details about why the metric was deactivated
     
   • sys_created_on: When the deactivation occurred

Check Metric Configuration

1. Navigate to System Definition > Tables
2. Search for and open the sn_getwell_metric table
3. Find your metric of interest
4. Review these key fields:
   
   • active: Current activation status (true/false)
     
   • runtime_threshold: Maximum allowed runtime in seconds
     
   • fail_count_threshold: Number of consecutive failures before automatic deactivation
     
   • aggregate_limit: Controls how many records are processed (can be adjusted to improve performance)

Common Solutions

Always ensure your instance is on latest Data Foundations Dashboard.

If issue still exist:

1. For Data Foundations Dashboard version below v2.2

• No recommended workaround available for this version. Upgrade to version 4.1.1 or higher version.

2.For Data Foundations Dashboard version on v2.2

• The metric can be deactivated on sn_getwell_metric
  
  • Go to sn_getwell_metric.list
    
  • Find the slow-running metric
    
  • Set active=false
• This will deactivate the metric, and prevent it from being picked up by any subsequent jobs.

3.For Data Foundations Dashboard version on v2.3+

• The metric can be deactivated on sn_getwell_metric
  
  • Go to sn_getwell_metric.list
    
  • Find the slow-running metric
    
  • Set active=false
• This will deactivate the metric, and prevent it from being picked up by any subsequent jobs.
• Additionally, this version supports auto deactivation of the slow-running job if it exceeds our runtime threshold for by default 3 times.

Additional Resources

Landing page

CMDB and CSDM Data Foundations Dashboard common error scenarios