Data Foundations Dashboard FAQ - CMDB/CSDM Metric Collection Scheduled Job is slow or not executed

[Siyou Li]

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

[ObianujunwaN]

@Siyou Li please i need your help, our CMDB/CSDM Data foundations dashboard was working well until we upgraded to the latest version 4.1.2 , everything got broken , the csdm dashboard is not displaying correctly any more, on the Business Apps relationship to Apps services metric its showing a value of zero 0, which is incorrect , i have tried trouble shooting with the steps you listed above , there are no jobs with a status of failed or threshold exceeded , they all show a status of complete , yet no records to display. please is this a known error ? or can you guide me on how i can further troubleshoot this before opening a Hi ticket .see screen shot attached .