3 Replies Latest reply on Nov 25, 2013 10:56 PM by randrianiriana

    Node Management : Server error: Internal Server Error

    randrianiriana


      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 http://myserver:8080/Orion/Services/Information.asmx/Query


      POST request :


      {"query":"\tSELECT I.InterfaceID AS ID, I.StatusLED, I.Caption, I.Index, I.Name, I.FullName, I.Unmanaged

      , I.AdminStatus, I.TypeDescription, N.EngineID, N.NodeID, N.IPAddress, N.DNS, N.SysName, N.WebCommunityString

      .GUID, N.IPAddressType, N.ObjectSubType, N.Caption AS NodeCaption, II.UnManageFrom, II.UnManageUntil

       \tFROM Orion.NPM.Interfaces I \tINNER JOIN Orion.Nodes N ON I.NodeID=N.NodeID \t LEFT JOIN Orion.NPM

      .EW.Nodes EW ON (I.NodeID = EW.NodeID) JOIN ( SELECT II.InterfaceId, '12/30/1899 12:00

      :00 AM' AS UnManageFrom, '12/30/1899 12:00:00 AM' AS UnManageUntil FROM Orion.NPM.Interfaces II WHERE

       II.UnManageUntil < getUtcDate() OR II.UnManageUntil IS NULL UNION ( SELECT II.InterfaceId

      , II.UnManageFrom, II.UnManageUntil FROM Orion.NPM.Interfaces II WHERE UnManageUntil > getUtcDate

      () AND UnmanageUntil IS NOT NULL ) ) II ON I.InterfaceId = II.InterfaceId \tWHERE N.Vendor='Cisco'

        ORDER BY I.Caption ASC \tWITH ROWS 1 TO 1"}


      RESPONSE :


      {"Message":"Error: A query to the SolarWinds Information Service failed.","StackTrace":" at Information

      .DoQuery(String query, String serverName, IDictionary`2 parameters)\r\n at Information.DoQueryWithRetries

      (String query, String serverName, IDictionary`2 parameters)\r\n at Information.Query(String query)"

      ,"ExceptionType":"System.Exception"}


      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,