Submit a ticketCall us

WebinarUpcoming Webinar: Know What’s Changed – with NEW Server Configuration Monitor

Change management in IT is critical. But, even with a good change management process, changes are too often not correctly tracked, if at all. The configuration of your servers and applications is a key factor in their performance, availability, and security. Many incidents can be tracked back to an authorized (and sometimes unauthorized) configuration change, whether to a system file, configuration file, or Windows® Registry entry. Join SolarWinds VP of product management Brandon Shopp to discover how the new SolarWinds® Server Configuration Monitor is designed to help you.

Register now.

Home > Success Center > Network Performance Monitor (NPM) > 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: 3,395 Votes: 0 Revisions: 8


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)


NPM 11.5.2



  • 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.
    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