Submit a ticketCall us

Announcing NCM 7.7
With NCM 7.7, you can examine the rules that make up an access control list for a Cisco ASA device. Then you can apply filters to display only rules that meet the specified criteria, order the rules by line number or by the hit count, and much more.
See new features and improvements.

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
13:49, 3 Aug 2016

Tags

Classifications

Public