Submit a ticketCall us

AnnouncementsTHWACKcamp 2018 is here

2018 is the seventh year for THWACKcamp™, and once again we’ll be live October 17 – 18 with packed session tracks covering everything from network monitoring and management, to change control, application management, storage, cloud and DevOps, security, automation, virtualization, mapping, logging, and more.

Register for online sessions.

Home > Success Center > Orion Platform > Orion - Knowledgebase Articles > 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 Caroline Juszczak on Aug 22, 2018

Views: 1,560 Votes: 0 Revisions: 12

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 can be done via MS SQL Management Studio.

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