Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > Virtualization Manager (VMAN) > We are having difficulty communicating with the Orion server

We are having difficulty communicating with the Orion server

Updated March 14, 2017

Overview

When trying to access the Recommendations page after upgrading to VMan RC2, the following error is displayed:

We are having difficulty communicating with the Orion server.

Details of the error:

{ "data": { "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" }, "status": 500, "config": { "method": "POST", "transformRequest": [ null ], "transformResponse": [ null ], "headers": { "Accept": "application/json, text/plain, */*", "Content-Type": "application/json;charset=utf-8" }, "cache": false, "url": "http://192.168.234.90/orion/services...ion.asmx/query", "data": { "query": "SELECT DataGroupInfo.ID, DataGroupInfo.Type, DataGroupInfo.Name, Recommendations.RecommendationID,\nRecommendations.Priority, Recommendations.RecommendationKind, Batches.Status, Recommendations.Strategy.StrategiesGroupID,\n(CASE WHEN Recommendations.Tags LIKE '%Recommendations.IsNow%' THEN 1 ELSE 0 END) AS IsNow\nFROM Orion.Recommendations.DataGroupInfo AS DataGroupInfo \nINNER JOIN Orion.Recommendations.ActiveRecommendations AS Recommendations ON Recommendations.GroupID = DataGroupInfo.ID \nLEFT JOIN Orion.Recommendations.Batches AS Batches ON Batches.BatchID = Recommendations.BatchID \nLEFT JOIN Orion.Recommendations.Actions AS Actions ON Actions.RecommendationID = Recommendations.RecommendationID AND Actions.Primary = TRUE \n WHERE Batches.BatchID IS NULL ORDER BY Recommendations.Priority ASC, Recommendations.RecommendationKind DESC, IsNow DESC" } }, "statusText": "Internal Server Error" }

Environment

  • VIM 7.0.0
  • All VMan versions

Cause 

Previous version (RC1 or Beta) of Recommendations damaged the database.

Resolution

Note: Take a backup of your database.

  1. Stop all Orion services using Orion Service Manager.
  2. Using SQL Management Studio login to the database and drop all tables which starting with 'dbo.RE_'. (RE_Actions, RE_BathActions, RE_Recommendations, etc.)
  3. Run Configuration Wizard with Database option - to repair the database.
  4. Wait a while and then check Recommendations.

 

Last modified

Tags

Classifications

Public