Skip to main content

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

Documentation Team
  • Updated

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 (graph tile is blank) 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 <time period> at the resolution 'raw/hourly/daily'.

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 and resolution 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

  1. Install the latest version of SquaredUp DS

    Get the latest version of SquaredUp DS for SCOM

  2. Check the Data Warehouse connection

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

    See Troubleshooting the Data Warehouse connection.

  3. Check data is being collected

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

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

  4. Change the timeframe

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

    Why is no data shown?

    There may be no data points available if you are using hourly data and looking at the last 1 hour (metric > resolution 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 > resolution is set to daily and the tile or page timeframe is set to last 24 hours). Try changing the resolution to auto and the tile or page timeframe to a longer time period.

    The timeframe section allows you to determine the timeframe for the data. You can choose either to use:

    Use page timeframe

    The page timeframe is the timeframe setting a dashboard or perspective is currently using. These timeframes are all relative to the current time, for example 7 days ago until now. When a user changes the page timeframe, all tiles that have use page timeframe set will adapt to the new timeframe. (Tiles that do not have use page timeframe set (i.e. are set to specific timeframe or custom timeframe) are not affected and won't change.)

    The custom option can be used to set timeframes using ISO 8601 format

    SquaredUp DS does not support the week notation.

    Specific timeframe

    These timeframes allow you to set a fixed timeframe such as last 1 hour or last 7 days. You can use the sample relative timeframes button to get some examples for different timeframes. These timeframes are all relative to the current time, for example 7 days ago until now. Using this setting means that any change the user makes to the page timeframe is ignored.

    The custom option can be used to set timeframes using ISO 8601 format

    SquaredUp DS does not support the week notation.

    Custom timeframe

    This allows you to set a fixed timeframe window from the time and calendar picker. This sets a completely customizable timeframe window, not relative to now.

     

  5. Check the resolution

    Data resolution in the Data Warehouse

    Resolution refers to the raw, hourly or daily data stored in the Data Warehouse.

    The data available in the Data Warehouse is determined by the retention period set in SCOM.

    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 DS timeframes of 1 week or less will probably be using raw data, for timeframes between 30 days and 12 months SquaredUp DS will be probably be using hourly data. The SCOM data retention settings may well have been changed from the default.

    Understanding how SquaredUp DS uses the different resolution data from the Data Warehouse

    For Performance tiles the resolution is set in the Metric panel. Try changing metric > resolution to auto.

    SquaredUp DS, when using the auto resolution setting, uses the highest resolution data available (raw, hourly or daily), based on what data is available in the Data Warehouse for the whole graph timeframe. So SquaredUp DS will use raw data as long as it is available for the whole reporting timeframe, then it will use hourly, and when that is not available for the whole timeframe it will use daily data.

    For Performance tiles the resolution is set in metric > resolution

    Using the auto resolution setting on a Performance tile automatically changes to a more suitable resolution when the page timeframe is changed by a user, in order to optimize the time to return the graphs.

    The auto setting applies to visualizations that use time periods, such as line graphs, sparklines and reports. Visualizations that do not show a time period, such as Bar Top N, Heatmap and Scalar, use the latest data point. These visualizations do not change when a user changes the page timeframe. For these visualizations the auto resolution setting defaults to daily.

    Why is no data shown?

    There may be no data points available if you are using hourly data and looking at the last 1 hour (metric > resolution 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 > resolution is set to daily and the tile or page timeframe is set to last 24 hours). Try changing the resolution to auto and the tile or page timeframe to a longer time period.

    Why is daily, rather than hourly, data shown for a 6 month graph?

    When the retention period for hourly data is set to 180 days and a SquaredUp DS graph is set to display 6 months of data, this can actually be 182 or 183 days. SquaredUp DS will switch to daily data because hourly data is not available for the full 6 month period, i.e. the retention period is less than the date range. The solution is to modify the retention period to reflect 6 months i.e. an extra 5 days and set the retention period to 185 days, this should not affect your storage levels too greatly. After a few days this will resolve the problem because 6 months of hourly data will then be available, when SquaredUp DS checks the retention period against the requested time frame, the retention period would be higher and SquaredUp DS would show hourly data.

    For more information see How to optimize the Data Warehouse - 5 Point Plan - 4. Data Retention

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

 

 

Related articles

Comments

0 comments

Please sign in to leave a comment.