Archive

Archive for the ‘Moving Core Components’ Category

Migrating Operations Manager databases

April 21, 2010 Leave a comment

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

Moving Core Components

July 20, 2009 Leave a comment

This technet article shows how to upgrade Operations Manager core components
http://technet.microsoft.com/en-us/library/cc540402.aspx