Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

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 MindTouch on Jun 23, 2016

Views: 75 Votes: 0 Revisions: 6

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. 
  1. Delete the one NULL ESX Hosts from the VIM_HOSTS table.

  2. Back up the Orion database.
  3. Open Orion Database Manager from SolarWinds Orion > Advance Features.
  4. Select Default Server and drill down to VIM_Host Table.
  5. Run the following SQL Query and execute.
    Delete FROM VIM_HOSTS
    where HostID = 62

The issue should then be resolved with the web resource.

Last modified
22:40, 22 Jun 2016

Tags

Classifications

Public