Network Management

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

All Nodes Tress displays the error message Server Error: Unable to cast object of type ‘System.DBNull’ to type ‘System.String’.

First published date

10/19/2018 9:13 PM

Last published date

5/10/2022 5:50 PM

Overview

All Nodes Tress is showing the following error message:

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

 

Example "ALL Nodes" Image:

Product section

Network Performance Monitor

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

  8. However, if the NULL values are found in the IP_Address column, it's best to delete the entire row entry and re-add the Node if needed.

 

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

 

Example "Virtualization - Summary" Image:

 

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

 

 

  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 

  7. Click Enable table editing

  8. Delete row