Clone Excludes/Preservers are missing for Metric Intelligence MID Server extension contexts (ecc_agent_ext_context_metric) - Known Error

Clone Excludes/Preservers are missing for Metric Intelligence MID Server extension contexts (ecc_agent_ext_context_metric) Description Clone Excludes/Preservers are missing for Metric Intelligence MID Server extension contexts (ecc_agent_ext_context_metric). After a clone, on the clone target instance, this causes ghost/orphan records in the ecc_agent_ext_context table for these class of record, that when opened give a "Record not found" error.

The Metric Intelligence Context [ecc_agent_ext_context_metric] extension is used to collect and evaluate metrics.

Steps to Reproduce

Install Metric Intelligence on a pair of instances, to use as a clone source and target Install a MID Server on the target, and Distributed cluster On the clone target instance, set up the a Metric Intelligence Context [ecc_agent_ext_context_metric] extension Clone the source over the target. The ecc_agent_ext_context_metric record will now be corrupted, that when opened from the ecc_agent_ext_context list, gives a "Record not found" error, and the listeners will not be able to be started. Workaround This problem is currently under review and targeted to be fixed in a future release. Subscribe to this Known Error article to receive notifications when more information will be available.

Repair:

To repair bad records, please use this KB article: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0716609

To find the records, set the script up with: findOrphans('ecc_agent_ext_context', null, false);

Then to delete them use: findOrphans('ecc_agent_ext_context', null, false);

You may then need to set up the MID Server extensions/collectors/listeners again.

Prevention:

To prevent this in future, you will need to add Clone excludes and preservers for ecc_agent_ext_context and all the tables that extend it.

You can see a list of what child tables you have in your instance using this list filter: https:// .service-now.com/sys_db_object_list.do?sysparm_query=super_class.label%3DMID%20Server%20Extension%20Context%5EORsuper_class.super_class.label%3DMID%20Server%20Extension%20Context&sysparm_first_row=1&sysparm_view=