Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > Network Configuration Manager (NCM) > 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: 60 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
04:19, 23 Jun 2016

Tags

Classifications

Public