Clone Excludes/Preservers are missing for Event Management MID Server extension contexts (ecc_agent_ext_context_event / eif_listener_context) - Known Error

Clone Excludes/Preservers are missing for Event Management MID Server extension contexts (ecc_agent_ext_context_event / eif_listener_context) Description Clone Excludes/Preservers are missing for Event Management MID Server extension contexts (ecc_agent_ext_context_event / eif_listener_context). 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 MID WebService Event Listener Context [ecc_agent_ext_context_event] extension is used to accept event messages sent by an external event source to the MID Server, which processes the event message and then passes the event to the instance. The EIF listener context [ecc_agent_ext_context_event records] is for the collection of events from products that support the EIF format.

Steps to Reproduce

Install Event management on a pair of instances, to use as a clone source and target Install a MID Server on the target On the clone target instance, set up a MID WebService Event Listener Context [ecc_agent_ext_context_event] and EIF listener context [ecc_agent_ext_context_event records] Clone the source over the target. Those records will now be corrupted, that when opened from the ecc_agent_ext_context list, give 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=