Hide this message
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.
Updated October 10, 2016
All Nodes Tress is showing the following error message:
Server Error: Unable to cast object of type ‘System.DBNull’ to type ‘System.String’.
All Orion versions
There are NULLs to one of the columns of the node in the NodesData table of Orion database.
From the Orion server, launch Orion Database Manager (Start > All Programs > SolarWinds Orion > Advanced Features).
From the Orion Database Manager, click on Add Default Server.
Expand SQL server and look for the Orion database.
Expand Orion Database and look for NodesData table.
Right click NodesData Table and select Query Table.
Click on Execute Query
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