Running the Updating hierarchy report results in 'Transient error while performing requested operation'

  • Article ID: 65592
  • Updated: 10 May 2013

Issue 

While attempting to view the Updating hierarchy report in Enterprise Console 4, you see the following error message:

Transient error while performing requested operation
The server has run out of memory

Clicking the Advanced button on the error dialog shows text similar to:

The XML parse error 0xc00ce505 occurred on line number 35, near the XML text " ----- [outer exception] -----
-- error: 0x829D0001
-- facility: Unknown

First seen in

Enterprise Console 4.0.0

Fixed in
Enterprise Console 4.5.0

What to do

Sophos Technical Support have developed a patch to be used to correct this issue.

Note: This patch can only be used on SQL 2005/2008 Express and SQL 2005/2008. If you are running SQL 2000 or MSDE with Sophos Enterprise Console 4, please contact technical support.

  1. Download the file HRepPatch.txt from Sophos.com and rename it to HRepPatch.sql.

  2. We recommend that you back up the SOPHOS4 database by typing the following command in a command prompt:
    "%ProgramFiles%\sophos\enterprise console\DB\backupdb.bat"

    For help using this tool, please use the command "backupdb.bat /?"
  3. On the computer running the Sophos database, copy the sql file HRRepPatch.sql to %ProgramFiles%\sophos\enterprise console\DB\.
  4. Open a command prompt (Start | Run | cmd.exe) and type (press the enter key at the end of each line):

    CD "%ProgramFiles%\sophos\enterprise console\DB\"
    OSQL -E -S .\sophos -i HRepPatch.sql

    Where ".\sophos" represents the local Sophos named instance: please adjust this command if the SOPHOS4 database is in a different instance.
  5. To test the patch has been applied successfully, in Enterprise Console, from the Tools menu, select Report Manager and select the Updating Hierarchy report. It should complete without error.

Technical Information
In certain circumstances the text to be processed when running the Hierarchy report exceeds the size of the allocated buffer. The text is truncated, resulting in invalid XML.

at __w64 long __thiscall ReportManagerDlg::OnRun(unsigned short,unsigned short,struct HWND__ *,int &)
at __w64 long __thiscall CMainFrame::OnEMReporter(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)

 
If you need more information or guidance, then please contact technical support.

Rate this article

Very poor Excellent

Comments