Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

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