Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > Enterprise Operations Console (EOC) > NCM Configs page times out in EOC

NCM Configs page times out in EOC

 

Overview

NCM tab in EOC times out and EOC_ConfigArchive gets 10's of thousands of rows.

EOC.InformationService.log shows the following error prompt:

017-02-17 08:10:34,961 [27] ERROR SolarWinds.InformationService.Core.InformationService - Exception caught in method RunQuery
System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

 

 

Environment

All EOC versions

Cause 

There are too many configs to display. 

Resolution

Modify C:\Program Files (x86)\SolarWinds\EOC\Bin\Queries\NCM.xml. The Depth value will control how many hours of configs to download (default 1 year). There is an issue with Time Zone conversion between EOC and Orion and you have to add 24 hours to the desired depth value (ie: 48 for 2 days of configs + 24 = 72 for Depth value).

  <HistoryLimit>
                <Column>ModifiedTime</Column>
                <Depth>8760</Depth> <!-- 1 year in hours -->
                <Enabled>true</Enabled> <!-- If you want to poll all Config Archives, change the true to false -->
            </HistoryLimit>

 

 

 

Last modified

Tags

Classifications

Public