Submit a ticketCall us

WebinarUpcoming Webinar: Should I Move My Database to the Cloud?

So you’ve been running an on-premises SQL Server® for a while now. Maybe you’ve moved it from bare metal to a VM, and have seen some positive benefits. But, do you want to see more? If you said “YES!”, then this session is for you, as James Serra will review the many benefits that can be gained by moving your on-prem SQL Server to an Azure® VM (IaaS). He’ll also talk about the many hybrid approaches, so you can gradually move to the cloud. If you are interested in cost savings, additional features, ease of use, quick scaling, improved reliability, and ending the days of upgrading hardware, this is the session for you.

Register now.

Home > Success Center > Network Configuration Manager (NCM) > NCM - Knowledgebase Articles > Configuration Management devices cannot be selected or no device is listed

Configuration Management devices cannot be selected or no device is listed

Created by Malik Haider, last modified by Malik Haider on Jun 23, 2016

Views: 858 Votes: 2 Revisions: 6

Updated

Overview

This article will correct the issue when NCM Configuration Management devices cannot be selected or no device is listed

 

 

Troubleshooting 

  1. Go to the following log file: C:\ProgramData\SolarWinds\InformationService\v3.0\Orion.InformationService.log.
  2. Search for the ERROR at the bottom on the log file:

~~~~~~~~~

2016-06-16 11:58:14,316 [82] ERROR SolarWinds.InformationService.Core.InformationService - w3wp| /LM/W3SVC/2/ROOT-2-131105398949860725| |   Exception for Operation: <s:Envelope xmlns:s="http://www.w3.org/2003/05/soap-envelope" xmlns:a="http://www.w3.org/2005/08/addressing">

  <s:Header>

    <a:Action s:mustUnderstand="1">http://schemas.solarwinds.com/2007/0...rvice/QueryXml</a:Action>

    <a:MessageID>urn:uuid:ab859dd2-d203-4990-89c3-e9d9a826c65d</a:MessageID>

    <a:ReplyTo>

      <a:Address>http://www.w3.org/2005/08/addressing/anonymous</a:Address>

    </a:ReplyTo>

    <Impersonation xmlns="http://schemas.solarwinds.com/2007/0...rmationservice" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">

      <TargetUsername>CY\751245</TargetUsername>

    </Impersonation>

    <i18n xmlns="http://schemas.solarwinds.com/2007/0...rmationservice" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">

      <Culture>en-US</Culture>

    </i18n>

    <SwisSettings xmlns="http://schemas.solarwinds.com/2007/0...rmationservice" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">

      <AppendErrors>false</AppendErrors>

      <ApplicationTag>w3wp| /LM/W3SVC/2/ROOT-2-131105398949860725| | </ApplicationTag>

      <DataProviderTimeout>PT0S</DataProviderTimeout>

    </SwisSettings>

    <IsBase64EncodingAccepted xmlns="http://schemas.solarwinds.com/2007/0...rmationservice">true</IsBase64EncodingAccepted>

    <a:To s:mustUnderstand="1">net.tcp://as900g141:17777/SolarWinds/InformationService/v3/Orion/certificate</a:To>

  </s:Header>

  <s:Body>

    <QueryXml xmlns="http://schemas.solarwinds.com/2007/0...rmationservice">

      <query>

                SELECT NCMNodeProperties.NodeID AS NCMNodeID, 

                    Nodes.NodeID AS OrionNodeID,

                    Nodes.Caption AS Caption, 

                    Nodes.IP_Address AS IPAddress,

                    1 AS Level,

                    1 AS IsExpandable,

                    1 AS ShowCheckbox,

                    0 AS Checked,

                    Nodes.Status AS Icon,

                    '' AS OriginConfigType,

                    '' AS ParentConfigType,

                    0 AS IsBinary,

                    NCMNodeProperties.LastTransferActionType,

                    NCMNodeProperties.LastTransferDate,

                    NCMNodeProperties.LastTransferMessage,

                    NCMNodeProperties.IsTransferError,

                    NCMNodeProperties.IsActiveTransfer,

                    NCMNodeProperties.NodeGroup,

                    Nodes.MachineType,

                    Nodes.Vendor, 

                    Nodes.IOSVersion

                    ,OrionCustomProperties.City,OrionCustomProperties.Comments,OrionCustomProperties.Department,OrionCustomProperties.Imported_From_NCM

                FROM Cirrus.NodeProperties AS NCMNodeProperties                

        INNER JOIN Orion.Nodes AS Nodes ON NCMNodeProperties.CoreNodeID=Nodes.NodeID

                INNER JOIN Orion.NodesCustomProperties AS OrionCustomProperties ON OrionCustomProperties.NodeID=Nodes.NodeID

                WHERE  Comments='REUTERS'  AND (1=1) AND (1=1)

                ORDER BY Name ASC 

                WITH ROWS 1 TO 100 RETURN XML RAW</query>

      <parameters>

      </parameters>

    </QueryXml>

  </s:Body>

</s:Envelope>

2016-06-16 11:58:14,332 [82] ERROR SolarWinds.InformationService.Core.InformationService - w3wp| /LM/W3SVC/2/ROOT-2-131105398949860725| |   Exception caught in method SolarWinds.InformationService.Core.InformationService.RunQuery

SolarWinds.Data.Query.ParserException: Cannot resolve property Name

   at SolarWinds.Data.Query.Processor.SemanticChecker.HandleNonQualifiedPropertyName(EntityExpression entityExpression)

   at SolarWinds.Data.Query.Processor.SemanticChecker.Visit(EntityExpression entityExpression)

   at SolarWinds.Data.Query.Swql.ParseTreeDuplicatorNoState.Visit(OrderByColumn sortColumn)

   at SolarWinds.Data.Query.Processor.SemanticChecker.Visit(OrderByColumn sortColumn)

   at SolarWinds.Data.Query.Swql.ParseTreeDuplicatorNoState.Visit(OrderByClause orderBy)

   at SolarWinds.Data.Query.Processor.SemanticChecker.Visit(SelectStatement statement)

   at SolarWinds.Data.Query.Processor.SemanticChecker.Process(SelectStatement statement, PreProcessorState state)

   at SolarWinds.Data.Query.Processor.PreProcessor.Process(SelectStatement selectStatement, PreProcessorState& preProcessorState)

   at SolarWinds.Data.Query.Engine.QueryProcessor.ProcessInternal(String query, IQueryExecutionContext context)

   at SolarWinds.InformationService.Core.QueryPlanCache.GetQueryPlan(String query, String username, Boolean federationEnabled, Func`1 buildQueryPlan)

   at SolarWinds.InformationService.Core.InformationService.RunQuery(String query, IDictionary`2 parameters, IDataSerializer serializer)

Environment

NCM 7.5 and later

Cause 

There was a custom property called ‘Name’ on Orion.  This column was added to the Configuration Management grid and sorting was applied. NCM was still trying to sort based on this custom property even after it was removed.

Resolution

Go to NCM > Configuration Management page and click on any other column in grid. This will reset sorting and should resolve issue. 

 

 

 

Last modified

Tags

Classifications

Public