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) > Slowness and information service exceptions when running a VNQM query

Slowness and information service exceptions when running a VNQM query

Overview

 

In certain versions of VNQM, you may experience unusual slowness. You can investigate 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 VoipGatewayEndpoints.VoipGatewayEndpointID, VoipGatewayEndpoints.VoipGatewayID, VoipGatewayEndpoints.IfName, VoipGatewayEndpoints.DisplayName, VoipGatewayEndpoints.EndPointType, VoipGatewayEndpoints.Status, VoipGatewayEndpoints.IfIndex, VoipGatewayEndpoints.DetailsUrl, VoipGatewayEndpoints.StatusDescription, VoipGatewayEndpoints.StatusLED, VoipGatewayEndpoints.Image, VoipGatewayEndpoints.AncestorDisplayNames, VoipGatewayEndpoints.AncestorDetailsUrls, VoipGatewayEndpoints.StatusIconHint, VoipGatewayEndpoints.Description, VoipGatewayEndpoints.Uri, VoipGatewayEndpoints.WebUri.WebUri
 FROM Orion.IpSla.VoipGatewayEndpoints   WHERE   ORDER BY VoipGatewayEndpoints.DisplayName RETURN XML AUTO

ERROR SolarWinds.InformationService.Core.InformationService - (null) 
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:28c990a3-7ae2-495c-a28f-160ed38eee0d</a:MessageID>
    <a:ReplyTo>
      <a:Address>http://www.w3.org/2005/08/addressing/anonymous</a:Address>
    </a:ReplyTo>
    <i18n xmlns="http://schemas.solarwinds.com/2007/0...rmationservice" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
      <Culture>en-US</Culture>
    </i18n>
    <a:To s:mustUnderstand="1">net.tcp://localhost:17777/SolarWinds/InformationService/v3/Orion/ad</a:To>
  </s:Header>
  <s:Body>
    <QueryXml xmlns="http://schemas.solarwinds.com/2007/0...rmationservice">
      <query>SELECT VoipGatewayEndpoints.VoipGatewayEndpointID, VoipGatewayEndpoints.VoipGatewayID, VoipGatewayEndpoints.IfName, VoipGatewayEndpoints.DisplayName, VoipGatewayEndpoints.EndPointType, VoipGatewayEndpoints.Status, VoipGatewayEndpoints.IfIndex, VoipGatewayEndpoints.DetailsUrl, VoipGatewayEndpoints.StatusDescription, VoipGatewayEndpoints.StatusLED, VoipGatewayEndpoints.Image, VoipGatewayEndpoints.AncestorDisplayNames, VoipGatewayEndpoints.AncestorDetailsUrls, VoipGatewayEndpoints.StatusIconHint, VoipGatewayEndpoints.Description, VoipGatewayEndpoints.Uri, VoipGatewayEndpoints.WebUri.WebUri
 FROM Orion.IpSla.VoipGatewayEndpoints   WHERE   ORDER BY VoipGatewayEndpoints.DisplayName RETURN XML AUTO</query>
      <parameters>
      </parameters>
    </QueryXml>
  </s:Body>
</s:Envelope>

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 before 4.2.2 (SR1)

Resolution

 

This issue is fixed in VNQM 4.2.2

 

To resolve this issue, SolarWinds recommends upgrading to VNQM 4.2.2, because there are other issues solved in this release.

 

 

Last modified

Tags

Classifications

Public