Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

Home > Success Center > Network Performance Monitor (NPM) > Admin accounts unable to log in to the Web Console

Admin accounts unable to log in to the Web Console

Created by Dennis Harnett, last modified by Aileen de Lara_ret on Mar 27, 2017

Views: 23 Votes: 0 Revisions: 7

Updated: February 21, 2017

Overview

Admin accounts are unable to log in to the Web Console with the following error message:

Error 500

 

When this issue occurs the Core.BusinessLayer.log (located in C:\ProgramData\Solarwinds\Logs\Orion by default) shows the below error:

2033-11-18 19:39:11,163 [83] ERROR SolarWinds.Orion.Core.BusinessLayer.DowntimeMonitoring.DowntimeMonitoringNotificationSubscriber -
Exception occured when processing incoming indication of type "System.InstanceModified"
System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_ObjectDownTime'. Cannot insert duplicate key in object 'dbo.NetObjectDowntime'. The duplicate key value is (Jan 18 2033 19:39PM, 2836, Orion.NPM.Interfaces).
The statement has been terminated.
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)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at SolarWinds.Orion.Common.SqlHelper.ExecuteNonQuery(SqlCommand command, SqlConnection connection, SqlTransaction transaction)
   at SolarWinds.Orion.Core.Common.DALs.NetObjectDowntimeDAL.Insert(NetObjectDowntime item)
   at SolarWinds.Orion.Core.BusinessLayer.DowntimeMonitoring.DowntimeMonitoringNotificationSubscriber.OnIndication(String subscriptionId, String indicationType, PropertyBag indicationProperties, PropertyBag sourceInstanceProperties)

Environment

NPM version 11.5.2

Cause 

This is an issue in the internal interface downtime monitoring notification subscriber component and is addressed in NPM 12.

 

Resolution

Upgrade to NPM 12 or later

OR

Disable this internal component:

SELECT TOP 1000 * FROM [dbo].[Settings]
WHERE SettingID LIKE 'SWNetPerfMon-Settings-EnableDowntimeMonitoring'
  1. Query the settings table though Database Manager:
  2. Enable table editing.
  3. Change CurrentValue to 0 to disable this feature.
  4. Log in as Admin.
  5. Restart the services.

 

 

Last modified
19:01, 26 Mar 2017

Tags

Classifications

Public