Submit a ticketCall us

Quickly Address Software Vulnerabilities
Patch Manager is an intuitive patch management software which extends the capabilities of WSUS and SCCM to not only patch Windows® servers and workstations, and Microsoft® applications, but also other 3rd-party applications which are commonly exploited by hackers. Learn more about our patch management solution.

 

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