Submit a ticketCall us

Don’t fall victim to a ransomware attack
Backups are helpful, but sometimes that’s not enough to protect your business against ransomware. At our live webcast we will discuss how to protect against ransomware attacks with SolarWinds® Patch Manager and how to leverage log data to detect ransomware. Register now for our live webcast.

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
17:14, 21 Mar 2017

Tags

Classifications

Public