Submit a ticketCall us

WebinarFREE IT Monitoring Webcast

Don’t miss out on our webcast, Essential IT Monitoring with SolarWinds ipMonitor, where we will show you how to keep an eye on your IT environment from one centralized, affordable, and lightweight monitoring tool: SolarWinds® ipMonitor®.

Register now.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > NPM upgrade issue due to invalid limitations

NPM upgrade issue due to invalid limitations

Table of contents
No headers
Created by Interspire Import, last modified by MindTouch on Jun 23, 2016

Views: 1,159 Votes: 1 Revisions: 7

Symptom:
After an NPM upgrade from version 10.1 to 10.5 there appears a message error (Invalid Column Name 'N1') at the summary nodes window.

Cause:
The error is normally caused by invalid limitations

Resolution: 
Please follow the below steps to resolve this issue by deleting the limitations:

** Before proceeding, we highly recommend doing a backup of the Orion database, as there will be manual manipulation of the Orion database **
1. Open Database Manager on the Orion Server:
[Start > All Programs > SolarWinds Orion > Advanced Features > Database Manager]
2. Ensure that the SQL server that is hosting Orion DB is added. If it is not, please add it in.
3. After adding, expand the SQL server, and you will notice Orion DB.
4. Expand it further and you will see a number of tables. (Right Click) on any one of them and select "Query Table..."
Paste the following into the text box (replacing the default query):
DELETE FROM Limitations
WHERE
WhereClause = '1=1'
5. Select "Refresh" 

Last modified

Tags

Classifications

Public