Home > Moving Core Components > Migrating Operations Manager databases

Migrating Operations Manager databases

When moving the Operations Manager Databases, it appears that sometimes the sys.messages table in the master database does not populate with the user messages which are inserted as a part of the installation of the operations manager db install. This causes the reporting datawarehouse setup to fail. The following SQL statement can be run against the master DB to insert the user messages – you then need to rerun the setup but make sure that you uninstall Reporting on the old server, before you run the setup.

As always, use these scripts at your own risk. If in doubt, contact Microsoft PSS.

— UserRoleAdministratorAlreadyExistsException
EXECUTE sp_addmessage @msgnum = 777980100, @msgtext = N’A user role with the
administrator profile already exists. Cannot create another user role with the same

profile.’, @severity = 16, @lang = ‘us_english’, @with_log = false, @replace =
‘REPLACE’
GO

— UserRoleSystemDeleteException
EXECUTE sp_addmessage @msgnum = 777980101, @msgtext = N’Cannot delete system user

roles.’, @severity = 16, @lang = ‘us_english’, @with_log = false, @replace =
‘REPLACE’
GO

— UserRoleSystemException
EXECUTE sp_addmessage @msgnum = 777980102, @msgtext = N’Cannot create user roles
with IsSystem specified.’, @severity = 16, @lang = ‘us_english’, @with_log = false,

@replace = ‘REPLACE’
GO

— NULL is not a valid Group Id for the Scope specified
EXECUTE sp_addmessage @msgnum = 777980103, @msgtext = N’NULL is not a valid GroupId

for the Scope specified.’, @severity = 16, @lang = ‘us_english’, @with_log = false,

@replace = ‘REPLACE’
GO

— NULL is not a valid TypeId for the Scope specified
EXECUTE sp_addmessage @msgnum = 777980104, @msgtext = N’NULL is not a valid TypeId

for the Scope specified.’, @severity = 16, @lang = ‘us_english’, @with_log = false,

@replace = ‘REPLACE’
GO

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: