Submit a ticketCall us

Putting Your Logs Where They Belong with the New SolarWinds Log Manager for Orion

The new SolarWinds® Log Manager for Orion® finally puts your log data right where it belongs, in the heart of your Orion console. Gain insight into the performance of your infrastructure by monitoring your logs in a unified console allowing you to see a wealth of information about the health and performance of your network and servers.

Reserve a Seat for Wednesday May 23rd 11am CDT | Reserve a Seat for Tuesday May 22nd 10:30am GMT | Reserve a Seat for Tuesday May 22nd 1pm SGT / 3pm AEST

Home > Success Center > Network Performance Monitor (NPM) > Unable to manage alerts in the Web Console

Unable to manage alerts in the Web Console

Updated August 29, 2017

Overview

Some users are not able to manage alerts in the web console. The page is blank.

 

Environment

  • Orion Platform 2016.1
  • Orion Platform 2016.2

Cause 

This can occur when there are Action Assignments for non-existing actions.

 

Similar error to the following located in the Orionweb.log:

ERROR NewAlertingService - (null)  Failed to retrieve alerts.
System.InvalidCastException: Cannot cast DBNull.Value to type 'System.Int32'. Please use a nullable type.
   at System.Data.DataRowExtensions.UnboxT`1.ValueField(Object value)
   at System.Data.DataRowExtensions.Field[T](DataRow row, String columnName)
   at NewAlertingService.<>c.<GetAlerts>b__4_9(DataRow x)
   at System.Linq.Enumerable.WhereSelectListIterator`2.MoveNext()
   at System.String.Join[T](String separator, IEnumerable`1 values)
   at NewAlertingService.GetAlerts(String property, String type, String value, String search)

Resolution

  1. Back up the ActionsAssignments DB table with data to avoid any risks.
  2. Run the following query which should delete obsolete action assignments:
DELETE FROM ActionsAssignments WHERE ActionID NOT IN (SELECT ActionID FROM Actions)
 

 

Last modified

Tags

Classifications

Public