Submit a ticketCall us

WebinarFREE IT Monitoring Webcast

Don’t miss out on our webcast, Essential IT Monitoring with SolarWinds ipMonitor, where we will show you how to keep an eye on your IT environment from one centralized, affordable, and lightweight monitoring tool: SolarWinds® ipMonitor®.

Register now.

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