Submit a ticketCall us
Home > Success Center > VoIP & Network Quality Manager (VNQM) > Gateway devices are not being polled

Gateway devices are not being polled

Created by Matthew Lamb, last modified by MindTouch on Jun 16, 2016

Views: 5 Votes: 0 Revisions: 4

Overview

This article goes over a known issue that can occur where gateways added into VNQM are not polled correctly. The stats for the endpoints and channels do not show up in the database and the following error is found in the DataProcessor_IPSLA.PRITrunk.CLI.log files under the Collector plugin logs:

2016-05-04 05:23:25,341 [STP SmartThreadPool Thread #332] ERROR IpSla.Collector.PRITrunkPollingPlan - Error in CommitResultToDatabase method.
System.Data.SqlClient.SqlException (0x80131904): Cannot assign a default value to a local variable.
Must declare the scalar variable "@id".
Must declare the scalar variable "@id".
Must declare the scalar variable "@id".
Must declare the scalar variable "@id".
Must declare the scalar variable "@id".
Must declare the scalar variable "@id".
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteScalar()
   at SolarWinds.Orion.Common.SqlHelper.ExecuteScalar(SqlCommand command, SqlConnection connection, SqlTransaction transaction)
   at SolarWinds.Orion.Common.SqlHelper.ExecuteScalar(SqlCommand command)
   at SolarWinds.Orion.IpSla.Collector.DAL.PRITrunk.PRITrunkResultsDAL.InsertVoipGatewayEndpoint(Int32 voipGatewayID, VoipGatewayEndpointRecord voipGatewayEndpointRecord, DateTime dateTime)
   at SolarWinds.Orion.IpSla.Collector.Technology.PRITrunk.PRITrunkPollingPlan.CommitResultToDatabase(Object customCollectionKey, IEnumerable`1 bags)
ClientConnectionId:2939912e-4a2b-449d-a978-9af61f509722

 

Environment

VNQM 4.2 and later

 

Cause 

The issue is caused by the version 2005 SQL server that the Orion database is contained within. VNQM 4.2 and higher does not support this version due to the query set that it uses for the gateways, so the database cannot process the polling requests correctly.

 

Resolution

Upgrade your SQL Server from 2005 to any version at or above SQL Server 2008 for full support in VNQM.

 

Last modified
16:28, 16 Jun 2016

Tags

Classifications

Public