Pre-sensor script "Create reference bw MSSQL Components and Windows Server" failed due to: TypeError: Cannot convert null to an object - Known Error

Pre-sensor script "Create reference bw MSSQL Components and Windows Server" failed due to: TypeError: Cannot convert null to an object Description Error when discovering MS SQL: Pattern "MSSql DB On Windows" throws error: Pre-sensor script "Create reference bw MSSQL Components and Windows Server" failed due to: TypeError: Cannot convert null to an object

This happens when "Lightweight identification for MSSQL" Identification Section is used

Steps to Reproduce

> Run disovery to server hosting MSSQL > Make sure "MSSql DB On Windows" pattern is launched and "Lightweight identification for MSSQL" Identification Section is used > Pattern will fail with error: Pre-sensor script "Create reference bw MSSQL Components and Windows Server" failed due to: TypeError: Cannot convert null to an object

Workaround > Open pre post sensor: Create reference bw MSSQL Components and Windows Server"

> Insert the workaround lines below:

if (payloadItems[i].className === 'cmdb_ci_db_mssql_instance') { var currentItem = payloadItems[i]; relatedItems = currentItem.related;

//Workaround if(relatedItems == null || relatedItems.length==0) continue;

for (var j = 0; j if (relatedItems[j].className === 'mssql_components_info') { var currentComponentItem = relatedItems[j]; currentComponentItem.values["install_on"] = window_server; } }