Notifications

20 views

Description

"DiscoverySensor" is running SQL query with "`name` IS NULL" that overloads the DB when the cmdb table is huge. This causes high response times during discovery.

Steps to Reproduce

1. Enable discovery plugin
2. Configure a MID server that can discover a Windows Server with TIBCO ActiveMatrix BusinessWorks
3. Run discovery

Workaround

1. Go to System Definition -> Script Includes -> DiscoverySensor

2. Scroll down to line 757 of the script

3. Add the extra check in the sensor script include as follows:

From:

if (gs.nil(ci))
return null;

To:

if (gs.nil(ci) || ci == "null") {
return null;

4. Save the script include


Related Problem: PRB1351955

Seen In

London Patch 6

Intended Fix Version

Orlando

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:2019-07-10 18:35:11
Published:2019-07-11