Submit a ticketCall us

whitepaperYour VM Perplexities Called, and They Need You to Read This.

Virtualization can give you enormous flexibility with future workloads and can be a key enabler for other areas, like cloud computing and disaster recovery. So, how can you get a handle on the performance challenges in your virtual environment and manage deployments without erasing the potential upside? Learn the four key areas you need to be focusing on to help deliver a healthy and well-performing data center.

Get your free white paper.

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,163 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