When you select 'Configure Email Alerts' in Enterprise Console, version 4, an error is displayed (0x80004005)

Issue
This issue is seen following an upgrade from Enterprise Console version 3 to version 4. This article describes a workaround for this known issue (Def 49972).

In the Enterprise Console, when you select Tools|Configure Email Alerting, an error is displayed:

An unexpected error has occurred.
Click the "Advanced" button for information...

When you click the Advanced button, additional information is given which includes the following:

The specified event is not recognised.
----- [outer exception] -----
-- error: 0x80004005 (Unspecified error)
-- facility: Generic (System)

The full text of the message is given in the Technical information section below.

What to do

Rename the email subscription names in the database as follows:

1. Close the Enterprise Console.
2. Optionally backup the database using backupdb.bat (can be found in "%ProgramFiles%\Sophos\Enterprise Console\DB\").
3. From a command prompt run the following two commands, each must be typed on one line:
   • osql -E -S .\sophos -d Sophos4 -Q "update EmailAlertRecipients set Subscriptions=replace(cast(Subscriptions as nvarchar (4000)), 'WarningDifferFromPolicy', 'WarningDiffer')"
   • osql -E -S .\sophos -d Sophos4 -Q "update EmailAlertRecipients set Subscriptions=replace(cast(Subscriptions as nvarchar (4000)), 'CriticalDifferFromPolicy', 'CriticalDiffer')"
   where .\sophos refers to the local SOPHOS instance. If an alternative instance is being used, edit this in before running the command.
4. Re-open Enterprise Console and confirm that the issue is resolved.

Technical information

Clicking on the Advanced button on the Error dialog box provides the following information:

The specified event is not recognised.
----- [outer exception] -----
-- error: 0x80004005 (Unspecified error)
-- facility: Generic (System)

at __w64 long __thiscall CMainFrame::OnConfigureEmailAlerts(unsigned short,unsigned short,struct HWND__ *,int &)at int __cdecl Run(int,enum bl::ConsoleType::Type)
at int __stdcall wWinMain(struct HINSTANCE__ *,struct HINSTANCE__ *,wchar_t *,int)