Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Data collection query no longer works following upgrade to NCM 7.9

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

Find more posts tagged with

Accepted answers

All comments

There are no accepted answers yet