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) > Reports are unable to work after Report Owner is disabled, removed, or now has limitation

Reports are unable to work after Report Owner is disabled, removed, or now has limitation

Created by James Fahey, last modified by MindTouch on Jun 23, 2016

Views: 735 Votes: 0 Revisions: 4

Overview

This article describes the issue when Reports are not working after Report Owner is disabled, removed, now has limitations, or has disable session time out enabled.

Environment

  • Orion Core version 2015.X
  • NPM version 11.5.X

Cause 

This issue occurs when the original report owner is disabled, deleted/removed, was implemented limitation or the account has the disable session time out enabled.

Resolution

  1. Reactivate the user account or change the ownership of the report:

    Warning: Changing the ownership may return different results due to various user limitations.

  2. Create a backup of the database.
  3. Click Start > All Programs > SolarWinds Orion > Advanced Features > Database Manager.
  4. Click Add Default Server and expand down to your SolarWinds database.
  5. Double-click the Report Definitions table.
  6. Delete the default query and replace with the following (Note this will change Owner for all Reports): 
    UPDATE ReportDefinitions
    SET Owner = '{new user}'
    WHERE Owner = '{old user}'
  7. Click Execute Query. 
    Notes:
    • For a list of accounts, check the Accounts table.
    • Pay attention to letter casing in account names.
  8. To change individual Report Owners, find selected report, click Enable Table Editing, click the Owner Field and change it to the desire Owner.
  9. After updating the DB, restart Orion Services.

 

Last modified
23:27, 22 Jun 2016

Tags

Classifications

Public