How to solve empty ENU display names of user roles in Operations Manager 2007 R2?

To upgrade Operations Manager 2007 R2 to version 2012 all user roles need to have display names in the ENU locale. Otherwise the upgrade fails.

The following blog describes how to find out if all user roles have the correct display names: For non default roles it is also possible to open up the user roles in a console which is installed on a machine with the ENU locale and simply change something in the description. This also creates the missing ENU display strings.

In our environment we had something strange.  A default role “Operations Manager Report Security Administrators” had no display name. How can I solve that, because I cannot delete the role?

Go to SQL server management studio and run the following command against the OpsManager DB:

select * from Localizedtext where LTValue like ‘%Operations Manager Report Security Administrators%’

The result only shows entries from the DEU languagecode. So update the entries with the following query:

update LocalizedText set LanguageCode = ‘ENU’ where LTStringId = ‘50585907-7858-4488-AB9C-13E0EAAC08BE’

Now the language code is set to ENU, which is supported and the upgrade should run without a problem.


Published by


* 1974, female, working as a IT Senior System Analyst in a chemical company. Main topics: System Center Operations Manager 2012, System Center Orchestrator 2012, System Center Configuration Manager 2012. Monitoring servers since 2002, started with NetIQ Appmanager. Twitter: @NatasciaHeil

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your 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