Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
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 MindTouch on Jun 23, 2016

Views: 476 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