Submit a ticketCall us

Putting Your Logs Where They Belong with the New SolarWinds Log Manager for Orion

The new SolarWinds® Log Manager for Orion® finally puts your log data right where it belongs, in the heart of your Orion console. Gain insight into the performance of your infrastructure by monitoring your logs in a unified console allowing you to see a wealth of information about the health and performance of your network and servers.

Reserve a Seat for Wednesday May 23rd 11am CDT | Reserve a Seat for Tuesday May 22nd 10:30am GMT | Reserve a Seat for Tuesday May 22nd 1pm SGT / 3pm AEST

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: 1,299 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

Tags

Classifications

Public