Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

Home > Success Center > Network Performance Monitor (NPM) > Unable to add a new AD user

Unable to add a new AD user

Created by Mariusz Handke, last modified by MindTouch on Jun 23, 2016

Views: 34 Votes: 1 Revisions: 8

Overview

This article provides information on addressing an issue occurring while adding Active Directory individual account and receiving the following error:

Object reference not set to an instance of an object.

 

 

Environment

All Orion Core versions

Cause 

There is a missing account limitation which was applied to the Active Directory group added to the Orion and then removed from it but relevant group member accounts (already stored in Orion) are not being updated.

Resolution

Step 1

Check if the limitation is missing

a. Open Orion Database Manager.

b. Use below query to display currently set limitations against all accounts:

SELECT LimitationID1 FROM Accounts WHERE LimitationID1!=0
UNION
SELECT LimitationID2 FROM Accounts WHERE LimitationID2!=0
UNION
SELECT LimitationID3 FROM Accounts WHERE LimitationID3!=0

Note: To copy content without line numbers, hover over the text and click the view source button (View Source). This opens a new window where you can select and copy text without any formatting or line numbering.

 

c. Use below query to find missing limitations (LimitationID):

SELECT LimitationID1 AS LID FROM
(
SELECT LimitationID1 FROM Accounts WHERE LimitationID1!=0
UNION
SELECT LimitationID2 FROM Accounts WHERE LimitationID2!=0
UNION
SELECT LimitationID3 FROM Accounts WHERE LimitationID3!=0
) AS SQ
WHERE SQ.LimitationID1 NOT IN
(
SELECT LimitationID FROM Limitations
)

Note: To copy content without line numbers, hover over the text and click the view source button (View Source). This opens a new window where you can select and copy text without any formatting or line numbering.

 

Step 2

If the output of point c in Step 1 has returned any values, you may need clear the limitation settings in the Accounts table (set its value to 0).

a. Use below query to set value to 0 for LimitationID1.

UPDATE Accounts
SET LimitationID1=0
WHERE LimitationID1 IN
(
SELECT DISTINCT LimitationID1 FROM Accounts
WHERE LimitationID1 NOT IN
(
SELECT LimitationID FROM Limitations
)
AND LimitationID1!=0
)

Note: To copy content without line numbers, hover over the text and click the view source button (View Source). This opens a new window where you can select and copy text without any formatting or line numbering.

 

b. Use below query to set value to 0 for LimitationID2.

UPDATE Accounts
SET LimitationID2=0
WHERE LimitationID2 IN
(
SELECT DISTINCT LimitationID2 FROM Accounts
WHERE LimitationID2 NOT IN
(
SELECT LimitationID FROM Limitations
)
AND LimitationID2!=0
)

Note: To copy content without line numbers, hover over the text and click the view source button (View Source). This opens a new window where you can select and copy text without any formatting or line numbering.

 

c. Use below query to set value to 0 for LimitationID3.

UPDATE Accounts
SET LimitationID3=0
WHERE LimitationID3 IN
(
SELECT DISTINCT LimitationID3 FROM Accounts
WHERE LimitationID3 NOT IN
(
SELECT LimitationID FROM Limitations
)
AND LimitationID3!=0
)

Note: To copy content without line numbers, hover over the text and click the view source button (View Source). This opens a new window where you can select and copy text without any formatting or line numbering.

 

 

In case these do not help, please open a ticket with Technical Support.

 

Last modified
23:49, 22 Jun 2016

Tags

Classifications

Public