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 > VoIP & Network Quality Manager (VNQM) > SWIS logs - ERROR SolarWinds.InformationService.Core.InformationService - (null)

SWIS logs - ERROR SolarWinds.InformationService.Core.InformationService - (null)

Created by Harry Griffiths, last modified by Eric Bryant on Dec 20, 2016

Views: 128 Votes: 2 Revisions: 6

Overview

In certain versions of VNQM, you may experience unusual slowness. You can investigate this by looking at the SolarWinds Information Service (SWIS) log files. When reviewing the SWIS logs, you may find an exception running a specific query:

 

ERROR SolarWinds.InformationService.Core.InformationService - (null) 
Exception running query:
SELECT InfrastructureNodes.InfrastructureNodeID, InfrastructureNodes.NodeID, InfrastructureNodes.DisplayName, InfrastructureNodes.Status, InfrastructureNodes.DetailsUrl, InfrastructureNodes.StatusDescription, InfrastructureNodes.StatusLED, InfrastructureNodes.Image, InfrastructureNodes.AncestorDisplayNames, InfrastructureNodes.AncestorDetailsUrls, InfrastructureNodes.StatusIconHint, InfrastructureNodes.Description, InfrastructureNodes.Uri
 FROM Orion.IpSla.InfrastructureNodes   WHERE   ORDER BY InfrastructureNodes.DisplayName RETURN XML AUTO
ERROR SolarWinds.InformationService.Core.InformationService - (null) 
Exception caught in method RunQuery
SolarWinds.Data.SWQL.SWQLSyntaxException: no viable alternative at input 'ORDER' in Where clause ---> Antlr.Runtime.NoViableAltException: A recognition error occurred.
   at SolarWinds.Data.SWQL.Parser.SWQLParser.negatedExpression()
   --- End of inner exception stack trace ---
   at SolarWinds.Data.SWQL.Parser.SWQLParser.negatedExpression()
   at SolarWinds.Data.SWQL.Parser.SWQLParser.logicalAndExpression()
   at SolarWinds.Data.SWQL.Parser.SWQLParser.logicalOrExpression()
   at SolarWinds.Data.SWQL.Parser.SWQLParser.expression()
   at SolarWinds.Data.SWQL.Parser.SWQLParser.logicalExpression()
   at SolarWinds.Data.SWQL.Parser.SWQLParser.whereClause()
   at SolarWinds.Data.SWQL.Parser.SWQLParser.queryRule()
   at SolarWinds.Data.SWQL.Parser.SWQLParser.selectStatement()
   at SolarWinds.Data.SWQL.Parser.SWQLParser.statement()
   at SolarWinds.Data.SWQL.SWQLParser.Parse(String query)
   at SolarWinds.Data.Query.Engine.QueryProcessor.ProcessInternal(String query, IQueryExecutionContext context)
   at SolarWinds.InformationService.Core.QueryPlanCache.GetQueryPlan(String query, String username, Func`1 buildQueryPlan)
   at SolarWinds.InformationService.Core.InformationService.RunQuery(String query, IDictionary`2 parameters, IDataSerializer serializer)

 

Environment

VNQM Versions earlier than 4.2.2 (SR1)

 

Resolution

This issue is fixed in VNQM 4.2.2 (SR1). To resolve this issue, SolarWinds recommends upgrading to VNQM 4.2.2 (SR1), because there are other issues solved in this release.

 

If you cannot upgrade, perform the following steps to as a workaround:

  1. Stop the Orion services using the Orion Service Manage.
  2. Go to the following folder: C:\Program Files (x86)\SolarWinds\Orion\Information Service\3.0\Schemas.
  3. Search for the file IpSlaSchema.xml.
  4. Make a backup of IpSlaSchema.xml and the IpSlaSchema.resx files. (Do not leave the backup in the installation directory) 
  5. Edit IpSlaSchema.xml file with following changes:

     

 Search for entity

 

name="Orion.IpSla.VoipGateways". 

 

Replace the following property element:

 

<property name="NodeID" type="System.Int32" displayName="$Orion.IpSla.VoipGateways.NodeID.displayName" groupBy="true" filterBy="true" />

 

with the following property element.

 

<property name="NodeID" type="System.Int32" key="True" displayName="$Orion.IpSla.VoipGateways.NodeID.displayName" groupBy="true" filterBy="true" />

 

Search for  entity name="Orion.IpSla.InfrastructureNodes". Replace the following property element

 

<property name="NodeID" type="System.Int32" displayName="$Orion.IpSla.InfrastructureNodes.NodeID.displayName" groupBy="true" filterBy="true" />

 

with the following property element.
 

<property name="NodeID" type="System.Int32" key="True" displayName="$Orion.IpSla.InfrastructureNodes.NodeID.displayName" groupBy="true" filterBy="true" />

 

 6. Start The Orion services using the Orion Service Manager.

Last modified
10:55, 20 Dec 2016

Tags

Classifications

Public