Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Server & Application Monitor (SAM) > SAM - Knowledgebase Articles > Error: There was an issue while rendering resource with id xxx

Error: There was an issue while rendering resource with id xxx

Created by Riggs Clough, last modified by Andrew.C.Smith on Mar 15, 2018

Views: 5,849 Votes: 6 Revisions: 7

Overview

This article describes the issue when using a custom SQL resource that takes a large amount of time to execute and you receive the following error:

There was an issue while rendering resource with id xxx

Environment

  • All versions of SAM
  • All versions of NPM custom resource using SQL

Cause 

This issue occurs when the query taking longer to execute than the timeout value indicated in the SWNetPerfMon.db file.

Resolution

 

  • Verify the SQL server is not having performance issues
  • Navigate to C:\Program Files (x86)\SolarWinds\Orion.
  • Copy a backup of SWNetPerfMon.DB file on a separate folder on the server.
  • Edit the original SWNetPerfMon.DB file.
  • Scroll at the bottom Database Command Timeout In Seconds
  • Under Database Command Timeout In Seconds change the commandtimeout value to a value greater than the time it takes to execute this query.

 

Last modified

Tags

Classifications

Public