Account Limitation: Default Device Error

I'm trying to create multiple user accounts that are limited to only displaying Interface Details for specified interfaces, but am running into an error. I can successfully select the Single Interface to limit the account to, however, after selecting "Interface Details" for the Home Page View I attempt to select the Default Device by clicking "Edit" and get the following error:

Orion Website Error

An error has occurred with the Orion website.

Additional Information

System.IndexOutOfRangeException: Node 3 is not in the Nodes table.   at SolarWinds.Orion.Web.NetObjectFactory.Create(String netObjectId)   at SolarWinds.Orion.NPM.Web.Interface.get_Node()   at SolarWinds.Orion.NPM.Web.Interface.get_Name()   at Orion_Admin_EditDefaultNetObject.OnInit(EventArgs e)   at System.Web.UI.Control.InitRecursive(Control namingContainer)   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Does anyone have any advice on how to resolve this issue? I have no issues when creating an account limited to a single node and selecting the default device node, but can't seem to get anywhere with the single interface option. Any help would be appreciated.

Find more posts tagged with

account_limitation_website_error

Accepted answers

mark_wiggans

That column should not be encrypted. I would run the SW diagnostics and examine the corresponding results. The Diagnostics Utility can be found in C:\Program Files\Solarwinds\Orion\SolarwindsDiagnostics.exe [assuming a default install path]. These results may possibly shed more light on what is occurring. See if you can then open the DB - folder -> Nodes excel page to view them>?

All comments

derek.sperry

So it looks like the Script that is trying to populate a list of interfaces to select default from is failing out because past nodes have been deleted and therefore Node 3, 6, 35, 43, etc. do not exist in the SQL Database. Does anyone know if there is a way to change the NodeIDs (since they are encrypted in SQL) or a way to change the script on that page to include a fail > ignore command?

Also, could the reps at Solarwinds please note this bug and recitify the situation in a future release of Orion? Thank you!

derek.sperry

Bump, anyone have any ideas?

mark_wiggans

It appears that you might have a row in your Interfaces table whose NodeID points to a non-existent node.

You could use Database Manager to find all interfaces associated with NodeID 3 (SELECT * FROM Interfaces WHERE NodeID=3) and delete them. That should get the Limitations working again.

What version and SP are you running?

derek.sperry

Thanks for the suggestion, however, I am getting the following error when trying to run that query:

"Conversion failed when converting the nvarchar value {.................} to data type int."

Currently running Orion 8.5.1.