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 > Network Performance Monitor (NPM) > Report resource failed to properly initialize

Report resource failed to properly initialize

Created by Dennis Harnett, last modified by Brian.Jarchow on Jun 26, 2017

Views: 192 Votes: 0 Revisions: 5

Overview

Reports fail to run intermittently. A resource fails to initialize. There are SQL errors in the logs, and event viewer.

Issue appears to be sql related.

Environment

NPM 11.5.2 through 12.1

Resolution

Service was unable to open a new database connection when requested.

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.)
Connection string - Data Source=EPBYMINSA0080t5\Infrastructure;Initial Catalog=NetPerfMon;Persist Security Info=False;User ID=SolarwindsNPM;Password=*******;Connect Timeout=20;Load Balance Timeout=120;Packet Size=4096;Application Name=w3wp@/LM/W3SVC/2/ROOT-1-131055500019036793;Workstation ID=SolarWinds


There are a number of long running queries in the logs:

C:\Users\SDAsvc\AppData\Local\Temp\DiagnosticsAnalyzer\5d9501bb-eca6-435e-ab1b-4e02b8a27315\Diagnostics\LogFiles\InformationServiceV3\Orion.InformationService.log, Line 23116, Message: '2016-04-24 02:29:30,655 [32] WARN SolarWinds.InformationService.Core.InformationService - (null) Support! -- LONG RUNNING QUERY: Session uuid:1e924326-f641-4606-abc9-ccaef27db18c;id=17 - Query took 19678.7153 ms: SELECT AlertObjectID FROM Orion.AlertObjects ao LEFT JOIN Orion.NPM.Interfaces no ON ao.EntityUri=no.Uri WHERE no.Uri IS NULL AND ao.EntityType = 'Orion.NPM.Interfaces' RETURN XML RAW'

These all point to an SQL performance/connection issue. See the following Microsoft articles for further information:

Enable TCP/IP Network Protocol for SQL Server

How to: Enable or Disable a Server Network Protocol (SQL Server Configuration Manager)

 

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment.  You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.

 

Last modified
11:57, 26 Jun 2017

Tags

Classifications

Public