Submit a ticketCall us

Systems Monitoring for Dummies
Our new eBook will teach you the fundamentals and help you create monitors and alerts that are effective, meaningful, and actionable. Monitoring is more than a checkbox on your to-do list. This free eBook will give you practical advice to help you succeed in all aspects of monitoring – discovery, alerting, remediation, and troubleshooting. Don’t miss out on this indispensable resource for newbies, experienced IT pros, and everyone in between. Register Now.

Home > Success Center > Server & Application Monitor (SAM) > Empty Web Console screens after SQL migration or restore

Empty Web Console screens after SQL migration or restore

Created by Shawnda Recksiedler, last modified by Rodim Suarez on Mar 07, 2017

Views: 14 Votes: 0 Revisions: 4

Overview

Some screens in the Web Console are blank or empty such as Alerts or Manage Actions after an SQL migration or an SQL DB restore of the Orion repository.

Environment

  • All Orion versions
  • All SAM versions

Cause 

This is caused by referential integrity issues in the database. This can result from a filesystem backup of an active/hot database or filecopy of a hot database.

Filesystem backups or filesystem copies must be done on a cold/shutdown database. Otherwise backups on an active database can be done through hot database backups.

Resolution

Redo the migration with a new database backup and restore or filesystem restore where backup was done on a shutdown SQL database.

 

Last modified

Tags

Classifications

Public