Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Network Performance Monitor (NPM) > All Nodes Tree - Server Error: Unable to cast object of type ‘System.DBNull’ to type ‘System.String’

All Nodes Tree - Server Error: Unable to cast object of type ‘System.DBNull’ to type ‘System.String’

Updated October 10, 2016

Overview

All Nodes Tress is showing the following error message:

Server Error: Unable to cast object of type ‘System.DBNull’ to type ‘System.String’.

System.String-I.png

 

Example "ALL Nodes" Image:

System.String-II.png

 

Environment

All Orion versions

Cause 

There are NULLs to one of the columns of the node in the NodesData table of Orion database.

Resolution

  1. From the Orion server, launch Orion Database Manager (Start > All Programs > SolarWinds Orion > Advanced Features).

  2. From the Orion Database Manager, click on Add Default Server.

  3. Expand SQL server and look for the Orion database.

  4. Expand Orion Database and look for NodesData table.

  5. Right click NodesData Table and select Query Table.

  6. Click on Execute Query

  7. Identify which columns contains the NULL values. List those column name.

    For Example: If you see NULL on the columns SysObjectID, Contact, IOSImage, you should update those NULL values to blank. This can be done by running the query below:

     

    Update NodesData set SysObjectID = ('') where SysObjectID is Null
    Update NodesData set Contact = ('') where Contact is Null
    Update NodesData set IOSImage = ('') where IOSImage is Null

 

 

If the issue shows on your Virtualization - Summary follow this steps:

 

Example "Virtualization - Summary" Image:

System.String-IV.png

 

 

System.String-VI.png

When clicking on "View Details", the page shows:
Unexpected Website Error
Unable to cast object of type 'System.DBNull' to type 'System.String'.

 

System.String-I.png

 

Resolution
  1. From the Orion server, launch Orion Database Manager (Start > All Programs > SolarWinds Orion > Advanced Features).

  2. From the Orion Database Manager, click on Add Default Server.

  3. Expand SQL server and look for the Orion database.

  4. Expand Orion Database and look for VIM_Host table.

  5. Click on Execute Query

  6. Identify which column contains the NULL value. example: HostName System.String-V.png

  7. Click Enable table editing

  8. Delete row

 

 

 

 

Last modified

Tags

Classifications

Public