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) > Manage Alerts not available on Web Console

Manage Alerts not available on Web Console

Updated November 3, 2016

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
20:12, 22 Mar 2017

Tags

Classifications

Public