Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

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