Hello all,
I can't manage nodes, I got "Server error: Internal Server Error" on "Manage Nodes" page (Admin > Node Managment) .
I can't list my nodes !/5.0.2/images/emoticons/sad.gif|___jive_emoticon_name=sad|class=jive_macro jive_emote|jivemacro=emoticon|src=/5.0.2/images/emoticons/sad.gif!
With firebug I see a request to myserver:8080/.../Query
POST request :
<p>{"query":"\tSELECT I.InterfaceID AS ID, I.StatusLED, I.Caption, I.Index, I.Name, I.FullName, I.Unmanaged</p><p>, I.AdminStatus, I.TypeDescription, N.EngineID, N.NodeID, N.IPAddress, N.DNS, N.SysName, N.WebCommunityString</p><p>.GUID, N.IPAddressType, N.ObjectSubType, N.Caption AS NodeCaption, II.UnManageFrom, II.UnManageUntil</p><p> \tFROM Orion.NPM.Interfaces I \tINNER JOIN Orion.Nodes N ON I.NodeID=N.NodeID \t LEFT JOIN Orion.NPM</p><p>.EW.Nodes EW ON (I.NodeID = EW.NodeID) JOIN ( SELECT II.InterfaceId, '12/30/1899 12:00</p><p>:00 AM' AS UnManageFrom, '12/30/1899 12:00:00 AM' AS UnManageUntil FROM Orion.NPM.Interfaces II WHERE</p><p> II.UnManageUntil < getUtcDate() OR II.UnManageUntil IS NULL UNION ( SELECT II.InterfaceId</p><p>, II.UnManageFrom, II.UnManageUntil FROM Orion.NPM.Interfaces II WHERE UnManageUntil > getUtcDate</p><p>() AND UnmanageUntil IS NOT NULL ) ) II ON I.InterfaceId = II.InterfaceId \tWHERE N.Vendor='Cisco'</p><p> ORDER BY I.Caption ASC \tWITH ROWS 1 TO 1"}</p>
RESPONSE :
<p>.DoQuery(String query, String serverName, IDictionary`2 parameters)\r\n at Information.DoQueryWithRetries</p><p>(String query, String serverName, IDictionary`2 parameters)\r\n at Information.Query(String query)"</p><p>,"ExceptionType":"System.Exception"}</p><p>{"Message":"Error: A query to the SolarWinds Information Service failed.","StackTrace":" at Information</p>
Already open a case on the support but it's too long ...
How can I fix this ?
I have to delete some nodes to able to add another interface. How can I delete nodes from SQL ?
I'm using "Orion Platform 2013.2.0, NPM 10.6, NTA 3.11.0, IVIM 1.8.1 "
Thank you.
Regards,