Slow query from the job - "Event Management - Update stuck connect"

The OOB Job: "Event Management  - Update stuck connect" (full name: "Event Management  - Update stuck connectors" /sysauto_script.do?sys_id=8c86a0809352120056f8f179077ffb86) runs every 2 mins and its purpose is to check for stuck connector instances.

This job calls the script include "EvtMgmtUpdateStuckConnectors" (sys_script_include.do?sys_id=63bd5b2053f003000238ddeeff7b1275) which generates a query (from lines 38 - 43) that unions all ecc_queue tables to filter for records on topic, queue, state and sys_updated_on (see filter condition below)

ecc_queue0000.`topic\`='ConnectorProbe' AND ecc_queue0000.\`queue\`='output' AND ecc_queue0000.\`state\`='error' AND ecc_queue0000.\`sys_updated_on\`>='2020-08-16 16:43:53'

This query may take anywhere from milliseconds to minutes, depending on the number of records in ecc_queue. Please note if ecc_queue does not participate in table rotation, the slow query will be on ecc_queue table only.

Please review System Diagnostics > Stats > Slow Queries for slow queries related to the job: "Event Management - Update stuck connect"

Please note that this KB is applicable for instances with the "Event Management" plugin (com.glideapp.itom.snac) installed.

There are 2 options:

a. Please import the attached xml in this KB for the script include: EvtMgmtUpdateStuckConnectors.

b. Upgrade the instance to a release that contains the fix for this PRB.