Unable to delete reconciliation rules from CI Class Manager

[pamartisrav]

A user with appropriate roles such as admin/cmdb_admin is unable to delete reconciliation rules from CI Class Manager.

When attempting to delete a rule, the system displays a success message, but the rule appears again afterward.

I verified that the record exists in both the tables:

cmdb_reconciliation_definition

cmdb_reconciliation_definition_mapping

However, the issue still persists.

Has anyone faced this issue before or knows if there is any background process causing the rule to reappear?

[Huynh Loc]

Hi @pamartisrav ,

This is a known issue with CI Class Manager reconciliation rules: the UI can show “deleted successfully” but the rule reappears due to inconsistency between cmdb_reconciliation_definition and cmdb_reconciliation_definition_mapping.
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0995619

ServiceNow Support documents that when the mapping is inconsistent, deleting/deactivating from CI Class Manager may not work. The recommended fix is to delete the rule directly from cmdb_reconciliation_definition and then recreate the reconciliation rule in CI Class Manager so records are re-generated correctly in both table.

If this response was helpful, please consider marking it as Correct and Helpful. You may mark more than one reply as an accepted solution.

[pamartisrav]

Hi @Huynh Loc ,

Thank you for your response. We have already reviewed the referenced knowledge article and verified suggested steps. The record which is present in the "cmdb_reconciliation_definition" table is also present in "cmdb_reconciliation_definition_mapping" table. However, the user is still unable to delete the rule. 

Please let me know if there are any other possible resolutions or additional checks we can perfom.

[Tanushree Maiti]

Hi @pamartisrav 

Cause

Usually, when we create reconciliation rules it will create records in the following two tables:

• "cmdb_reconciliation_definition" table, and then it creates a mapping in the "cmdb_reconciliation_definition_mapping" table.

If the record is not present in the "cmdb_reconciliation_definition_mapping" table but it is present in "cmdb_reconciliation_definition" table then deleting or deactivating will not work from the CI Class Manager.

 

Resolution

To resolve this you will have to delete the record from the "cmdb_reconciliation_definition" table and create the reconciliation rules again.

- This should now create the records in both "cmdb_reconciliation_definition" and "cmdb_reconciliation_definition_mapping" table.

Refer: KB0995619 Unable to delete Reconciliation Rules from CI Class Manager 

[pamartisrav]

Hi @Tanushree Maiti ,

Thank you for your response. We have already reviewed the referenced knowledge article and verified suggested steps. The record which is present in the "cmdb_reconciliation_definition" table is also present in "cmdb_reconciliation_definition_mapping" table. However, the user is still unable to delete the rule. 

Please let me know if there are any other possible resolutions or additional checks we can perfom.