Submit a ticketCall us

Systems Monitoring for Dummies
Our new eBook will teach you the fundamentals and help you create monitors and alerts that are effective, meaningful, and actionable. Monitoring is more than a checkbox on your to-do list. This free eBook will give you practical advice to help you succeed in all aspects of monitoring – discovery, alerting, remediation, and troubleshooting. Don’t miss out on this indispensable resource for newbies, experienced IT pros, and everyone in between. Register Now.

Home > Success Center > Archive > 2017December14 - Deletes > DBNull errors in EOC

DBNull errors in EOC

Created by Robert Stidman, last modified by Jessica Solis on Dec 14, 2017

Views: 42 Votes: 1 Revisions: 5

Overview

This article provides brief information and steps to resolve the following Enterprise Operations Console Web Console error:

Object cannot be cast from DBNull to other types.
Details
at System.DBNull.System.IConvertible.ToInt32(IFormatProvider provider)
at System.Convert.ToInt32(Object value)
at SolarWinds.EOC.Web.Resources.GenericMapper.Map(Property property, Object value, String thresholdName, IEnumerable`1 _thresholdsList, DataRow row, IEnumerable`1 childValues)
at SolarWinds.EOC.Web.Resources.OrionTableControl.FillData()
at SolarWinds.EOC.Web.Resources.OrionTableControl.Initialize(Boolean renderPanelOnly)

Environment

EOC version 2.x and earlier

Cause 

The error is caused when the web config file was configured incorrectly.

Resolution

  1. Locate and go to the web.config file.  By default, this file is located in C:\Program Files (x86)\SolarWinds\EOC\Website\web.config
  2. Create a copy of the web.config file and save it to your desktop.   
  3. Open the file in a text editor. 
  4. Find the following key:
    OrionInformationServicev2 
  5. Replace the value to net.tcp://{0}:17777/SolarWinds/InformationService/Orion/ssl.
  6. Refresh the page and add the server again.

 

 

Last modified

Tags

Classifications

Public