Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

 

 

 

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 Rodim Suarez on Mar 13, 2017

Views: 211 Votes: 0 Revisions: 4

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

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
18:20, 12 Mar 2017

Tags

Classifications

Public