Notifications

34 views

Description

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.

Steps to Reproduce

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.

Workaround

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.


Related Problem: PRB1421022

Seen In

There is no data to report.

Intended Fix Version

Quebec

Safe Harbor Statement

This "Intended Fix Version" information is meant to outline ServiceNow's general product direction and should not be relied upon in making a purchasing decision. The information provided here is for information purposes only and may not be incorporated into any contract. It is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at ServiceNow's sole discretion.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2020-09-28 23:32:08
Published:2020-09-29
sys_script_include_63bd5b2053f003000238ddeeff7b1275_PRB1421022.xml[View]