Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

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
17:49, 13 Mar 2017

Tags

Classifications

Public