Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

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