Reconciliation Engine multiple CI match issues

Reconciliation jobs might fail because the Reconciliation Engine finds multiple matches in the source or target (BMC.Asset) dataset. The jobs fail under the following circumstances:

• The Configuration Items (CI) remains unidentified in the source dataset after an Identification activity and the Reconciliation Engine log shows the message, The dataset ID and Reconciliation Identity combination is not unique. This error occurs when you create a new CI to represent a rediscovered object rather than unmarking a soft-deleted CI.

• The Configuration Items (CI) remains unidentified in the source dataset after an Identification activity and the Reconciliation Engine log shows the error message, Found multiple matches in the dataset: Cannot identify the instance of class <className> with instance ID <instanceId>.  This error occurs because the Find in Dataset field for the specific Identification Rule contains two or more CIs that share the same value for the attribute defined in the Identification Rule.

 The following topics provide information on resolving these issues:

To resolve duplicate CIs in the source dataset

1. In the BMC.CORE:BMC_BaseElement form, search for the CI in the source dataset using the specific reconciliation ID and dataset ID.
   The search might return more than one CI in the Source dataset with the same reconciliation ID and dataset ID.
2. If the search returns multiple CI records, determine whether any of them has been soft deleted. If so, delete the soft-deleted CI.
3. If the duplicate CI is not soft deleted, reexamine the Identification Rule to verify that the qualification that you specified fails to return unique CIs. If so, make appropriate corrections to the qualification.
4. Run the Reconciliation Engine Identification activity to identify the CI.

To resolve duplicate CIs in the BMC.Asset target dataset

1. In the BMC.CORE:BMC_BaseElement form, search for the duplicate CIs using the attribute values specified in the Find in Dataset field and any other attributes that you defined in the Identification Rule.
   For example, if you specified BMC.ASSET in the Find in Dataset field and 'TokenId' != $\NULL$ AND'TokenId' = $TokenId$ in the Qualification field of the Identification Rule, search for the duplicate CIs using these values in the Datasetid and Tokenid fields on the BMC.CORE:BMC_BaseElement form.
2. Perform the following steps to determine the problem:
   • Reexamine the Identification Rule to verify that the qualification that you specified fails to return unique CIs. If so, make appropriate corrections to the qualification.
   • Examine the quality of data in the BMC.ASSET dataset. If you find multiple CIs in the dataset that represent the same CI instance in your environment, delete all other duplicate entries.
     Only one CI must exist in the Find in Dataset with the specific dataset ID and reconciliation ID combination.
3. Run the Reconciliation Engine Identification activity to identify the CI.

Flowchart of duplicate CIs in the source dataset

The following figure illustrates the overall steps you need to perform to troubleshoot the duplicate CIs in your source dataset issue. 

Flowchart of duplicate CIs in the BMC.Asset target dataset

The following figure illustrates the overall steps you need to perform to troubleshoot the duplicate CIs in your source dataset issue. 

Related topics

Configuring core CMDB components and plug-ins

Enabling reconciliation job logs

Analyzing Reconciliation job logs