Loading...
Loading...
The encoded_query from function queryPrivAffinity within the "Insert Discovery Affinity & Cred Aliases" business rule lacks a control mechanism causing a large table handling warning when hostname is undefined. function queryPrivAffinity() { // source can be IP Address or hostname var source = current.source + ''; // if we can't validate as IP, see if it is a resolvable hostname // if it is not resolvable return null value in source if (!SncIPAddress.validate(source)) { source = (function(hostName) { var gr = new GlideRecord('cmdb_ip_address_dns_name'); gr.addQuery('dns_name.name', hostName); gr.query(); if (!gr.next()) return null; Steps to Reproduce 1. Choose an instance that has 1M or more records in cmdb_ci & cmdb_ip_address_dns_name 2. Turn on Debug SQL (Large tables) 3. Run SNMP or Windows Discovery 4. Check the SQL debugger log contains the query for cmdb_ip_address_dns_name for the chosen CI and it shows a warning similar to the one pasted below: ...worker.1 worker. 1 txid=258c888185 WARNING *** WARNING *** Large Table: Table handling an extremely large result set: 359027 Query that got us here is: TABLENAME = cmdb in address dns name ENCODED OUERY = dns name.names com.glide.db.OuervWarning.warn/QuervWarning.iava:44) com.glide.db.DBQuery.loadResultSet(DBQuery.java:4024) com glide dh DROuerv eyecute AndReturnTable/DROuerv iava 5931 BR-"Insert Discovery Affinity & Cred. Aliases' com.glide.caller.gen.sys script 5100a1e46faffdoOdbf9841dba3ee47f script.call(Unknown Source) com.glide.script.ScriptCaller.call/ScriptCaller.java:18
Upgrade instance to fixed release, or import attached business rule.
PRB1712133
Click on a version to see all relevant bugs
ServiceNow Integration
Learn more about where this data comes from
Bug Scrub Advisor
Streamline upgrades with automated vendor bug scrubs
BugZero Enterprise
Wish you caught this bug sooner? Get proactive today.