Submit a ticketCall us

WebinarDatabase Roundtable – Expert Database Professionals Feel Your Pain

In this video broadcast, Head Geek™ Tom LaRock is joined by Karen Lopez, Tim Chapman, and David Klee. They’ve known each other for many years, so this discussion was like four friends getting together to talk data and databases. They discussed diagnostic data collection, common performance root causes, reactive tuning versus proactive, and more. Join us for an engaging discussion on these topics! Plus, Tom LaRock will be available to answer your questions live.

Register now.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > Message: Unable to cast object of type 'System.DBNull' to type 'System.String'

Message: Unable to cast object of type 'System.DBNull' to type 'System.String'

Created by Kevin Twomey, last modified by Norbert Skurzewski on Apr 20, 2018

Views: 4,032 Votes: 0 Revisions: 8

Overview

The following error message is received for hosts with Problem Resource:

Unable to cast object of type 'System.DBNull' to type 'System.String'

The Web log shows the following error message:
ERROR SolarWinds.Orion.Web.UI.BaseResourceControl - Exception while loading resource

System.InvalidCastException: Unable to cast object of type 'System.DBNull' to type 'System.String'.

   at ASP.orion_vim_controls_vmobjectwithproblemsimpl_ascx.__DataBind__control5(Object sender, EventArgs e)

   at Orion_VIM_Resources_VMobjectWithProblemsImpl.ProcessLoad()

   at Orion_VIM_Resources_VMObjectWithProblemsForSummary.Page_Load(Object sender, EventArgs ea)

Environment

NPM 11.5.2

Resolution

Warning:

  • Consult your System Administrator before performing the following procedure. 
  • To resolve the issue you will need to delete the NULL ESX Hosts from the VIM_HOSTS table.

 

  1. Back up the Orion database.
  2. Open Orion Database Manager from SolarWinds Orion > Advance Features (or search in Start).
  3. Select Default Server and expand by clicking on the + sign
  4. Scroll down to VIM_Host Table.
  5. Run the following SQL Query and execute.
    Delete FROM VIM_HOSTS
    where HostID = 'number of the null host'

 

The issue should then be resolved with the web resource.

 

Important Note:

The null values will affect the host if they are anywhere in columns NodeID, DataCenterID, ClusterID, ManagedObjectID, HostName, VMwareProductName, VMwareProductVersion.

Look out for any duplicate hosts, if one of the duplicates has both HostID and NodeID values, and the other host has nulls for HostID or NodeID, remove the host that has the nulls.

Last modified

Tags

Classifications

Public