Skip to main content

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

Catherine
  • Updated

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'.

mceclip0.png

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 SquaredUp

Firstly, ensure you are running the latest version of SquaredUp.

B. Check the Data Warehouse connection

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

See Troubleshooting the Data Warehouse connection

C. Check data is being collected

SquaredUp 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 SquaredUp.

To do this in SquaredUp, browse to the object in SquaredUp, 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:

mceclip0.png

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: mceclip1.png

SquaredUp 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 SquaredUp timeframes of 1 week or less will probably be using raw data, for timeframes between 30 days and 12 months SquaredUp 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.

By default the scope of Performance tiles will look at multiple levels of membership (recursive search) for objects, so they 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. This means the tile shows data for objects that aren't directly contained in a group, but are contained within other objects. For example, this allows you to find disk metrics when scoped to a server.

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. By specifying a group AND a class it means that you can extend this recursive search to use top-level groups to show graph data for objects within sub-groups (as well as objects).

To enable recursive searching to work for sub-groups you should specify a group AND a class in the Advanced Scope. This will allow the dropdown list to show the metrics for the objects in the sub-groups.

% 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 SquaredUp 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

Related articles