Orion Web Console charts display Data is not available

11/29/2018 10:48 PM

4/21/2023 8:57 PM

Legacy or classic charts in the Orion Web Console display the following message: 

Data is not available.

Orion Platform

This list provides the most common causes of the "No Data is available" message:

• Incorrect date/time settings on the SQL Server
• The data is not in the database (not supported, not polled yet, not polled at all, already summarized)
• Customized widget settings (chart sample shorter than the polling interval, unsuitable variable)
• Customized general chart settings (customized chart settings hide the data)

I. Check the SQL server date and time

1. Correct the NTP server that was setting the wrong date/time.

II. Make sure the data is in the database
If you verified the items, the data should be available in the database. This will be dependent on the type of chart being reviewed and varies widely. With the introduction of Orion Log Viewer, an additional database is required. For SolarWinds Platform environments running 2022.3 and newer, there are three databases and their default names are SolarWindsOrion, SolarWindsOrionLog, and SolarWindsNetflowStorage, for the main database, Orion Log Viewer, and Netflow data respectively.

For example, a chart for CPU load on a node would have data stored in the CPULoad_CS_cur table. Please review Use Database Manager utility to view the SolarWinds Orion database for more information on how to confirm data in the tables.

III. Upgrade historical or legacy charts to modern charts
In Orion Platform 2018.4, modern charts were introduced. See A brief history of Orion Platform charts.
Consider using modern charts if available. See Modern charts replacing legacy and classic charts in Orion Platform 2018.4 and Migrate to modern charts for details.

IV. Verify settings for the chart with issues
Make sure that the sample interval on the chart is longer than the polling frequency for the data to display.
The chart should display the correct data. If it is not the case, verify the time variables in the chart. Select Edit on the upper right of the chart widget and adjust the Sample Interval then select Submit. Please note that this option requires the Manage Views permission to be set to Yes on the account.

By default, Nodes are polled every 10 minutes, Interfaces every 9 minutes, and Volumes every 15 minutes.

V. Verify the time variables used in the chart
When specifying the time period for the chart using time variables, use ${toTime} or ${toTimeUTC} instead ${untilTime}.
Alternatively, filter by time in the chart and not in the query.

VI. Verify general Chart settings and revert them to defaults
Customized general chart settings, such as the Maximum number of data series displayed chart or Chart Aspect Ratio, may prevent data from displaying on your charts as well. Consider reverting chart settings to defaults.
See Chart Settings for more information.

VII. Revert the Chart Settings to defaults using Web Console

1. In Main Settings & Administration, find the Thresholds & Polling grouping, and click Polling Settings. 

2. Review the interval for polling the statistics.

3. Click Edit in the chart, and adjust the Sample Interval on the chart so that it is not shorter than the polling interval.
   For example, when polling Nodes every 10 minutes, do not set the Sample Interval to 10 Minutes; use a longer interval instead.

4. Click Submit.

VIII. Use a query to verify the Maximum Number of Data Series Displayed on the Chart is too low:

1. Log in to the Orion Web Console as an administrator.

2. Click Settings > All Settings > Web Console Settings in the Product-Specific Settings grouping. 

3. Scroll down to Chart Settings, and locate the Maximum number of data series displayed on the chart.

4. Adjust this setting to a value greater than 10. 
   The default setting is 10. SolarWinds recommends adjusting this setting to no higher than 20.

5. Make sure that the Chart Aspect Ratio is set to a value above 3.

6. Save your settings.  

IX. Revert the Maximum number of data series to defaults using SQL:
The charts should now display all data in the data series.
1. Use Database Manager to view the SolarWinds database, add the database, and run the following query:

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

Select * from Settings where SettingID like '%Web-MaximalNumberOfSeriesInChart%'

2. If the query results are similar to the following table, the default settings have been changed.

SettingID	Name	CurrentValue	DefaultValue
Web-MaximalNumberOfSeriesInChart	Maximal Number Of Series In Chart	2	10

Restore the default settings.

1. Use Database Manager to view the SolarWinds database. 

2. Run the following query to reset the chart settings to default:

   -- Scripts are not supported under any SolarWinds support program or service.
   -- Scripts are provided AS IS without warranty of any kind. SolarWinds further
   -- disclaims all warranties including, without limitation, any implied warranties
   -- of merchantability or of fitness for a particular purpose. The risk arising
   -- out of the use or performance of the scripts and documentation stays with you.
   -- In no event shall SolarWinds or anyone else involved in the creation,
   -- production, or delivery of the scripts be liable for any damages whatsoever
   -- (including, without limitation, damages for loss of business profits, business
   -- interruption, loss of business information, or other pecuniary loss) arising
   -- out of the use of or inability to use the scripts or documentation.
   
   UPDATE Settings SET CurrentValue = 10 where SettingID like '%Web-MaximalNumberOfSeriesInChart%'

    

Additional points to checks 

• Restore the database to a date before the issue occurred.

• If you added the device within the last few minutes, wait 10 minutes so that Orion Platform can complete the polling cycle, and refresh your screen.

• Verify that the device was not in maintenance (unmanaged state) during the requested time. Click Settings > Manage Nodes, and check out the Status for the device. See Suspend collecting data for nodes.

• Verify that interfaces or volumes are monitored correctly. In Node Management, select the node, and click List resources and make sure the interfaces or volumes are selected.

• Verify that hardware health sensors on the device provide both status and values. If you are monitoring hardware health, some devices may report status only and do not report values that display in a chart. See Monitoring Hardware Health for details. 

• If you are monitoring NetFlow with SolarWinds NTA and cannot see any data, make sure you have configured devices properly to export flow data.

• Verify that historical data have not been summarized yet.

  • By default, detailed statistics are stored in the database for 7 days. After that, statistics collected within an hour are summarized, an average is calculated for each hour and stored in the database.
    Consider changing how long you want to keep detailed historical data in the database.
    Note: Changing default settings can require additional space in the SolarWinds Orion database. Consider your SQL environment resources, such as disk space and hardware configuration before you change the retention periods.

• Some metrics are not supported for all devices:

  • Meraki wireless controllers (NPM 12.1 and later): the Average Response Time and Packet Loss resources do not show data because these metrics are not supported for Meraki infrastructure. For Meraki, these metrics are polled from the cloud and thus might be misleading.

  • AIX nodes do not support Disk Queue Length and Disk Usage (response time).

Other Useful Articles

• Core Chart Settings
• Orion Web Console and Chart Settings
• NTA charts: Data not available
• NTA shows Data Not Available
• STM: Data is not available on Web Console charts for Storage Manager