Investigating CMDB Data Issues
Symptoms which indicate a CMDB Data or Reconciliation Issue
There are several different ways an issue with CMDB data can be discovered:
- Reconciliation job runs have errors, which are displayed in red in the status bar or displayed as a red job run icon when the reconciliation job completes.
Multiple Matches Founderror reported in Reconciliation job logs.
HostedSystemComponent cardinality violationerror reported in the Reconciliation job logs.
Could not find Endpoint in Relationshiperror reported in Reconciliation job logs.
- Data updates from Asset Management are not propagating
- When users search for a CI, multiple CI's are reported, indicating there are duplicates
Tools for investigating CMDB data issues
There are three primary methods for investigating CMDB data issues:
- Using the cmdbdiag utility on the CMDB server to check for and correct known data issues.
- Performing database queries to get counts of data matching conditions of a data failure.
- Choosing representative examples of Reconciliation failures and analyzing Reconciliation Job logs and data exports to identify the root cause of failure.
Recommended sequence to investigate CMDB data issues
When symptoms of CMDB data issues occur, it is a good practice to verify CMDB data using the following steps:
- Use cmdbdiag to fix data issues.
- Assess data distribution in the CMDB using queries.
- Investigate duplicate computer systems in CMDB if duplicates exist in the golden dataset.
- Modifying reconciliation identification rules to avoid duplicates.
- Removing duplicate CIs and re-identifying them.
- Using CMDB Data Analyzer to Investigate CMDB Data Issues