Network Management

Timeout Error in Orion Web Console: There was an error while loading data for this resource. Timeout expired. The timeout period elapsed

Data is not displayed and the following error is returned when running a Min/Max/Average bps In/Out report in Export mode, a resource page will too many resources, or from Report Manager for a large data set: There was an error while loading data for this resource. Timeout expired. The timeout period elapsed.

First published date

10/30/2018 3:10 PM

Last published date

8/19/2022 6:05 PM

Overview

Data is not displayed and the following error is returned when running a Min/Max/Average bps In/Out report in Export mode, or from Report Manager for a large data set:

There was an error while loading data for this resource.
Timeout expired. The timeout period elapsed.

 

Note: The following are examples of the view and the report without the error. 

Export view example:

 

Report example:

 

Product section

Network Performance Monitor

Cause

The SQL timeout in the NetPerfmon configuration file was set to 60 seconds. The time elapsed and was not enough for the large amount of data that was being pulled to complete. 

Resolution

  1. On the Orion server, Go to C:\Program Files (x86)\SolarWinds\Orion.
  2. Open the SWNetPerfMon.DB file.
  3. Locate the following settings at the bottom of the SWNetPerfMon.DB text file these are the default settings that should be set: 
    !    Connection timeout in seconds
Timeout=20
!
!    Database Command timeout in seconds
CommandTimeout=90
  4. If possible: Restart all SolarWinds services.
    1. Go to All Programs > SolarWinds Orion > Orion Service Manager.
    2. Shutdown Everything
    3. Once all services have stopped, restart services.
  5. Optional: You can also Increase the connection timeout on the IIS:
    1. Open IIS Manager, expand sites and select SolarWinds NetPerfMon
    2. On the Manage Web Site, go to Limits.
    3. Increase the Connection time-out to 600 seconds.
    4. Open the command prompt as an administrator and run the command iisreset.