Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Orion Platform > Orion - Knowledgebase Articles > Orion Web Console Information Service error

Orion Web Console Information Service error

Created by Norbert Skurzewski, last modified by Rodim Suarez_ret on Mar 02, 2017

Views: 387 Votes: 0 Revisions: 5

Overview

This article explains what to do when you see an Information Service error when trying to access the Orion Web Console.

Environment

NPM 11.5.3 and earlier

Cause 

There are pending notifications and subscriptions in the the Information Service logs.

Resolution

  1. Shutdown and stop all services in the Orion Service Manager.
  2. Go to Database Manager < Add Default Server.
  3. Expand your database and double click PendingNotifications.
  4. Remove the "SELECT TOP 1000 * " part of the query and replace it with "Delete" then execute the query.
  5. Double-click Subscriptions.
  6. Remove the "SELECT TOP 1000 * " part of the query and replace it with "Delete" then execute the query
  7. Double-click SubscriptionTags.
  8. Remove the "SELECT TOP 1000 * " part of the query and replace it with "Delete" then then execute the query.
  9. Go back to Service Manager and start everything.
  10. When all services are up and running go to your Orion Web Console to confirm the issue has been resolved.
 

 

Last modified

Tags

Classifications

Public