Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
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: 42 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