Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > Network Performance Monitor (NPM) > Virtual machine is not linked to nodes in Orion

Virtual machine is not linked to nodes in Orion

Table of contents
Created by Interspire Import, last modified by MindTouch on Jun 23, 2016

Views: 1,192 Votes: 0 Revisions: 11

Issue:

Virtual machines are not linked to nodes in Orion.

Cause:

Virtual machine mapping exception. The following error is found in VIM.BusinessLayer.log:

Exception in mapping Virtual machines to Nodes System.Data.SqlTypes.SqlNullValueException: Data is Null. This method or property cannot be called on Null values.

Resolution:

To resolve the VM mapping exception:
1. Stop Orion Services -
2. Create a backup of the Orion database. This is done via MS SQL Management Studio - Creating a Database Backup.

3. Run the following script in MS SQL Server Management Studio:
  UPDATE dbo.VIM_VirtualMachines SET NodeID=NULL WHERE NodeID NOT IN(SELECT NodeID FROM dbo.Nodes)
4. Run the DB maintenance:
  1.     Go to Start > Programs > SolarWinds Orion > Advanced Features > Database Maintenance
  2.     Click Start.
5. Start Orion services - How to Start/Stop Orion Services.
 
Last modified

Tags

Classifications

Public