Submit a ticketCall us
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