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:
- Close the Enterprise Console.
- Optionally backup the database using backupdb.bat (can be found in "%ProgramFiles%\Sophos\Enterprise Console\DB\").
- 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. - 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)