Submit a ticketCall us

WebinarUpcoming Webinar: Should I Move My Database to the Cloud?

So you’ve been running an on-premises SQL Server® for a while now. Maybe you’ve moved it from bare metal to a VM, and have seen some positive benefits. But, do you want to see more? If you said “YES!”, then this session is for you, as James Serra will review the many benefits that can be gained by moving your on-prem SQL Server to an Azure® VM (IaaS). He’ll also talk about the many hybrid approaches, so you can gradually move to the cloud. If you are interested in cost savings, additional features, ease of use, quick scaling, improved reliability, and ending the days of upgrading hardware, this is the session for you.

Register now.

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: 1,153 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