Notifications

99 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

Fixed In

Orlando

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-08-11 15:39:23
Published:2019-08-11