Submit a ticketCall us

Training ClassThe Orion® Platform Instructor-led Classes

Provided by SolarWinds® Academy, these trainings will introduce users to the Orion Platform and its features, management, and navigation. These courses are suitable for users looking to discover new tips, tricks, and ways to adapt their Orion products to better suit their monitoring needs:
Deploying the Orion Platform
Configuring Orion views, maps, and accounts
Configuring Orion alerts and reports

Reserve your seat.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > NPM stops collecting statistical data after upgrading to Orion Platform 2018.4

NPM stops collecting statistical data after upgrading to Orion Platform 2018.4

Updated: February 4, 2019

Overview

After you upgrade to NPM 12.4, the application stops collecting statistical data and the graphs do not display any data.

When you open the swdebugMaintenance.log file, the following error displays: 

2019-01-02 11:42:56,008 [4] INFO SolarWinds.Data.DatabaseMaintenance.TimeSeriesTableHandler+TimeSeriesMaintenanceExecutorContext - Running maintenance for ResponseTime_CS
2019-01-02 11:42:56,178 [4] ERROR SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - Error in thread: System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_ResponseTime_CS_Hourly_20181212'. Cannot insert duplicate key in object 'dbo.ResponseTime_CS_Hourly_20181212'. The duplicate key value is (2018-12-11 23:00:00.0000000, 3375).
The statement has been terminated.
Warning: Null value is eliminated by an aggregate or other SET operation.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at SolarWinds.Database.TimeSeries.Helpers.SqlHelper.ExecuteNonQuery(IDbConnection connection, String sql, IDbTransaction transaction, IEnumerable`1 parameters, CommandType commandType)
at SolarWinds.Database.TimeSeries.Helpers.SqlHelper.SolarWinds.Database.TimeSeries.Helpers.ISqlHelper.ExecuteNonQuery(String sql, IDbConnection connection, IDbTransaction transaction, IEnumerable`1 parameters, CommandType commandType)
at SolarWinds.Database.TimeSeries.Drivers.Legacy.LegacyMaintenanceExecutor.ExecuteMaintenance(String tableName, DateTime currentDate)
at SolarWinds.Database.TimeSeries.Drivers.MaintenanceExecutorBase.ExecuteMaintenance(String tableName, RetentionIntervals retentionIntervals, DateTime currentDate)
at SolarWinds.Data.DatabaseMaintenance.TimeSeriesTableHandler.PostMaintenance(DateTime basisDate)
at SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine.<>c__DisplayClass24_0.<TableHandlerWorker>b__7()
at SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine.ExecuteMaintenanceAction(Action maintenanceAction, String actionDescription)
at SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine.TableHandlerWorker(DatabaseMaintenanceThreadParameter value)
ClientConnectionId:a2d997b6-2159-467b-8658-5ab384d45555
Error Number:2627,State:1,Class:14

 When you open the Collector.service.log file, the following error displays: 

SolarWinds.Collector.DBProcessing.DBProcessingWorkerWithAccess - Commit of - Core.Node.ResponseTimeStatus.Icmp failed. System.Data.SqlClient.SqlException (0x80131904): The attempted insert or update of the partitioned view failed because the value of the partitioning column does not belong to any of the partitions.

Environment

  • NPM 12.4

  • Orion Platform 2018.4

Cause

Database maintenance fails to aggregate the data into the hourly tables from the detail tables, preventing new tables from being created. As a result, polling stops once it reaches the end of the detail tables. 

Last modified

Tags

Classifications

Public