This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Data collection query no longer works following upgrade to NCM 7.9

harris-dobson over 5 years ago

2019-01-21 20:30:02,046 [85] ERROR SolarWinds.InformationService.Core.InformationService - (null) (null) Exception running query:
SELECT NodeID, CoreNodeID, EngineID, NodeCaption, NodeGroup, AgentIP, AgentIPv6, ManagedProtocol, AgentIPSort, ReverseDNS, Status, Community, CommunityReadWrite, SNMPLevel, SysName, SysDescr, SysContact, SysLocation, SystemOID, Vendor, VendorIcon, MachineType, LastBoot, OSImage, OSVersion, ConfigTypes, NodeComments, Username, Password, EnableLevel, EnablePassword, DeviceTemplate, ExecProtocol, CommandProtocol, TransferProtocol, LoginStatus, UseHTTPS, UseUserDeviceCredentials, LastInventory, SNMPContext, SNMPUsername, SNMPAuthType, SNMPAuthPass, SNMPEncryptType, SNMPEncryptPass, AllowIntermediary, UseKeybInteractiveAuth, ResponseError FROM NCM.Nodes
2019-01-21 20:30:02,046 [85] ERROR SolarWinds.InformationService.Core.InformationService - (null) (null) Exception for Operation:
SELECT NodeID, CoreNodeID, EngineID, NodeCaption, NodeGroup, AgentIP, AgentIPv6, ManagedProtocol, AgentIPSort, ReverseDNS, Status, Community, CommunityReadWrite, SNMPLevel, SysName, SysDescr, SysContact, SysLocation, SystemOID, Vendor, VendorIcon, MachineType, LastBoot, OSImage, OSVersion, ConfigTypes, NodeComments, Username, Password, EnableLevel, EnablePassword, DeviceTemplate, ExecProtocol, CommandProtocol, TransferProtocol, LoginStatus, UseHTTPS, UseUserDeviceCredentials, LastInventory, SNMPContext, SNMPUsername, SNMPAuthType, SNMPAuthPass, SNMPEncryptType, SNMPEncryptPass, AllowIntermediary, UseKeybInteractiveAuth, ResponseError FROM NCM.Nodes
2019-01-21 20:30:02,046 [85] ERROR SolarWinds.InformationService.Core.InformationService - (null) (null) Exception caught in method SolarWinds.InformationService.Core.InformationService.RunQuery
SolarWinds.Data.Query.ParserException: Cannot resolve property DeviceTemplate

This collector was working fine the night before, but I upgraded from NCM 7.6 to 7.9 yesterday (as part of the paired upgrade to NPM 12.1 to 12.4).

Any advice on getting this working again would be massively appreciated, not sure if just the parameter name has changed in the newer versions maybe?

Regards

Nick