Hi,
When I try to add account limitation to user accounts in Orion I get the following error.
When I choose:
Single Network Node
Group of Nodes
Single Interface
Group of Interfaces
Group of Volumes
Orion Website Error
An error has occurred with the Orion website.
Additional Information
System.ArgumentException: An item with the same key has already been added.
at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
at SolarWinds.Orion.Web.DAL.LimitationDAL.GetNameValuePairs(Limitation limit)
at SolarWinds.Orion.Web.Limitation.GetNameValuePairs()
at Orion_Admin_EditLimitation.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
All the other choices seem to work.
I contacted Solarwinds support and got the following response.
"Thank you for contacting SolarWinds. This issue is caused by one or more nodes in the database with the same name. The quick fix would be to search the nodes table for duplicates, and if found, either rename on of the nodes in the System Manager, or delete if from the System Manager."
I looked through the system manager and did find a couple of entries that had the same name. I deleted the ones no longer needed and renamed the ones that I needed to keep.
I even rebooted the server.
I have also used the folloing sql code to search through the database on the dbo.Nodes Table to try and find the duplicates.
SELECT Caption, COUNT(*) AS Expr1
FROM Nodes
GROUP BY Caption
HAVING (COUNT(*) > 2)
SELECT IP_Address, COUNT(*) AS Expr1
FROM Nodes
GROUP BY IP_Address
HAVING (COUNT(*) > 2)
SELECT ObjectSubType, COUNT(*) AS Expr1
FROM Nodes
GROUP BY ObjectSubType
HAVING (COUNT(*) > 2)
SELECT NodeID, COUNT(*) AS Expr1
FROM Nodes
GROUP BY NodeID
HAVING (COUNT(*) > 2)
SELECT SysName, COUNT(*) AS Expr1
FROM Nodes
GROUP BY SysName
HAVING (COUNT(*) > 2)
With none returning any duplicates.
I contacted Solarwinds support again asking if they had a query I could run to find the duplicates and got the following response.
"As mentioned by Matt previously, this is caused by duplicate nodes in the database. We don't have a specific SQL statement for finding them.
You could try thwack.com (our networking community site), to see if they have any solutions."
So... Has anyone come across this in the past and have you got any ideas to help me solve this problem.
Many Thanks,
David