Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > 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: 609 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

Tags

Classifications

Public