Submit a ticketCall us

WebinarUpcoming Webinar: How Help Desk and Remote Support Pays for Itself

Learn how help desk software can simplify ticketing management, allow you to track hardware and software assets, and accelerate the speed of IT support and service delivery. Gain insights on how remote support tools allow your IT team to maximize their efficiency and ticket resolution by expediting desktop troubleshooting, ultimately helping keep end-users happy and productive.

Register here.

Home > Success Center > Virtualization Manager (VMAN) > VMAN - Knowledgebase Articles > VMAN capacity planning reports do not display data

VMAN capacity planning reports do not display data

Updated 28-12-2017

Overview

Capacity Planning Reports do not display data. There are no errors on the Web Console.

The following error is found on the Capacity Planning Business layer (VIM):

[STP SmartThreadPool Thread #1] ERROR SolarWinds.VIM.CapacityPlanning.BusinessLayer.Simulation.SimulationJobWorker - Exception while executing job [Report Definition ID: 3]: System.Data.SqlClient.SqlException (0x80131904): The PERCENTILE_DISC function is not allowed in the current compatibility mode. It is only allowed in 110 mode or higher. Incorrect syntax near 'median'.

Environment

  • VMAN 8.1

Cause 

The PERCENTILE_DISC function is not allowed in the current compatibility level. It is only allowed in 110 level or higher. 

Resolution

  1. Change the compatibility level on the database to 110 or higher.

 

For more information about changing the compatibility level, please check the Microsoft doc below:

https://docs.microsoft.com/en-us/sql...tibility-level

 (© 2017 Microsoft, available at https://docs.microsoft.com, obtained on December 28, 2017)

 

 

Last modified

Tags

Classifications

Public