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 > Archive > 2017December12 - Deletes > Gateway devices are not being polled

Gateway devices are not being polled

Created by Matthew Lamb, last modified by Kevin.Swinson on Dec 12, 2017

Views: 569 Votes: 0 Revisions: 5

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

Tags

Classifications

Public