Submit a ticketCall us

WebinarUpcoming Webinar: Know What’s Changed – with NEW Server Configuration Monitor

Change management in IT is critical. But, even with a good change management process, changes are too often not correctly tracked, if at all. The configuration of your servers and applications is a key factor in their performance, availability, and security. Many incidents can be tracked back to an authorized (and sometimes unauthorized) configuration change, whether to a system file, configuration file, or Windows® Registry entry. Join SolarWinds VP of product management Brandon Shopp to discover how the new SolarWinds® Server Configuration Monitor is designed to help you.

Register now.

Home > Success Center > Virtualization Manager (VMAN) > VMAN - Knowledgebase Articles > 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