Turn off workflows of related tables during remediation

Configure de-duplication remediation processes for related tables, to turn off the execution of business rules, workflows, and any other automatic processes that might be turning off the update of referenced duplicate CIs to the main CI. Disabling all these workflows of related tables, allow de-duplication tasks, that would otherwise fail, to complete.

About this task

Related tables (tables that reference CIs), might have for example, business rules that prevent the update of the referenced CI to the main CI during duplicate CI remediation. You can configure remediation processes to turn off all automated processes for specific tables, and by doing so, to allow remediation processes to complete. For example, ignore errors and skip ALL business rules, in such related tables. Those settings are stored in the De-duplication Related Table Configurations [reconcile_duplicate_related_table_config] table.

Each record in the reconcile_duplicate_related_table_config table represents a table with references to CIs. Settings in the De-duplication Related Table Configurations table are in effect during the processing of de-duplication tasks, but only if the system property glide.duplicate_ci_remediator.merge_related_items_enhanced is true (default value). In the base system, the De-duplication Related Table Configurations table contains records for the Change [change_request] and the Task CI [task_ci] related tables, which are configured to skip business rules and ignore database errors.

Add records to the De-duplication Related Table Configurations table to configure additional related tables for which you'd like to skip business rules and/or ignore database errors during de-duplication remediation.

For more information about the glide.duplicate_ci_remediator.merge_related_items_enhanced property or the De-duplication Related Table Configurations [reconcile_duplicate_related_table_config] table, see Properties related to remediation of duplicate CIs and Components installed for duplicate CI remediation.

Before you begin

Role required: cmdb_dedup_admin

Procedure

1. Select All and then, in the navigation filter enter reconcile_duplicate_related_table_config.list to open the De-duplication Related Table Configurations table.
2. Select New and fill out the following fields on the De-duplication Related Table Configurations table form:

   Field	Description
   Table Name	Table with references to CI for which settings apply during de-duplication remediation processes.
   Disable workflow	Disable the execution of all business rules, workflows, and any other automatic processes for the specified table during remediation.
   Proceed with errors	Skip any database errors for the specified table, during de-duplication remediation processes.
   Conditions for disabling workflow	Conditions that restricts the application of settings only to those records in Table Name that meet the condition. For example, in the base system, the change_request table is configured with the condition 'state is not New'. Therefore, when updating the change_request table during the remediation process, business rules are skipped only for those records in which 'state is not New'.

3. Select Submit.

What to do next

When configuring de-duplication remediation, you select which tables to include when merging related items. If any table that you select in that configuration step, has a record in the De-duplication Related Table Configurations table to disable workflow, an alert appears. Review that alert carefully, re-examine business rules and other automated processes to confirm your intention of disabling workflows for the respective table.