5 minute readApplies to: v4

No values found for the given metric for the last <time period> at the resolution '<raw/hourly/daily>'

Symptoms

A Performance tile or Matrix tile shows no graph or an error similar to the following:

The server encountered a problem whilst processing the request.
No values found for the given metric for the last 12 hours at the resolution 'raw/hourly/daily'.

No values found for the given metric

Cause

This error indicates that there is no data to show. There are several reasons why there may not be any data:

  • No data is being collected.

  • The SCOM collection rule is saving data to the Operations Manager database, but not to the Data Warehouse database.

  • For the chosen timeframe there is no data.

  • For the chosen scope and metric there is no data.

  • The group specified contains only subgroups and you have not specified, or have removed, the class.

Procedure

A. Install the latest version of Squared Up

Firstly, ensure you are running the latest version of Squared Up.

B. Check the Data Warehouse connection

If this message is shown for all performance graphs in Squared Up then you should check that Data Warehouse specified is correct.

See Troubleshooting the Data Warehouse connection

C. Check data is being collected

Squared Up uses data from the Data Warehouse database. If the data is available in SCOM this means the data is being collected and stored in the Operations Manager database. SCOM Reporting uses the Data Warehouse database, so if the data appears in a report then it is in the Data Warehouse.

Flush the health service state and cache to trigger the workflows to collect the data, either using SCOM or Squared Up.

To do this in Squared Up, browse to the object in Squared Up, then:

  1. Click on the Monitored Entity perspective.

  2. Click on Health Service in the Children section.

  3. Click the task button at the top of the page.

  4. Select the task Flush Health Service State and Cache.

  5. Click execute.

D. Change the timeframe

Change the page or tile timeframe, to see if there is data over a different period of time.

There may be no data points available if you are using hourly data and looking at the last 1 hour (metric > timeframe is set to hourly and the tile or page timeframe is set to last 1 hour), or using daily data and looking at the last 24 hours (metric > timeframe is set to daily and the tile or page timeframe is set to last 24 hours).

When the timeframe section has use page timeframe selected the tile will use the page timeframe. The page timeframe can be changed by any SCOM user browsing to the page.

Page timeframe:

Page timeframe

When the timeframe section has specific timeframe selected the tile will use the timeframe specified in the tile timeframe section. Only SCOM administrators or Team Folder authors/owners can edit the tile tileframe.

Tile timeframe: Tile timeframe

Squared Up uses raw data by default as long as it is available for the whole reporting timeframe, then it will use hourly, and when that is not available for the timeframe it will use daily data. Whether raw or hourly data is available for the whole timeframe will depend on your Data Warehouse data retention settings. Using the default SCOM data retention settings means that Squared Up timeframes of 1 week or less will probably be using raw data, for timeframes between 30 days and 12 months Squared Up will be probably be using hourly data. The SCOM data retention settings may well have been changed from the default. For more information see Data Retention

E. Check the metric

The quickest way to check the metric is correct, is to clear the existing metric and use the down arrow button on the keyboard to view all the metrics available for the scope you have chosen.

You may get the No values found for the given metric message returned if you change the scope after setting the metric.

If the scoped group contains only subgroups and you have not specified a class, then no metrics will be available in the metrics drop down list. The Performance tile in Squared Up v4 supports 'recursive' level searches for objects, so it will look at multiple-levels of membership rather than just one level, i.e. it will show objects that aren't directly contained in a group, but are contained within other objects in the group. This means you can now use top-level groups to show graph data for objects within sub-groups, by specifying a group AND a class in the Advanced Scope. Using a group that contains sub-groups (without a class) will not list any metrics in the drop down list.

% Processor Time

You may also see the No values found for the given metric message when using the metric % Processor Time. For Windows Server 2012 and 2008 R2 the SCOM metric is called Processor Information % Processor Time, whereas for other versions it is Processor % Processor Time. Some tiles, including the Squared Up Server 2008 perspective, may target the 2008 R2 metric, and so the error will show for 2008 servers. You can work around this by using a wildcard in the metric name, see How to use wildcards in metrics

How to use the Performance tile

Data Warehouse Performance Tuning - 5 point plan

Troubleshooting the Performance tile

How to use wildcards in metrics

Squared Up Ltd. (c) 2019Report an issue with this article