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) > 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: 10 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
23:14, 22 Jun 2016

Tags

Classifications

Public