Errors incorrectly shown against Update Managers in console

  • Article ID: 117664
  • Updated: 19 Nov 2013

Issue

In the Enterprise Console, on the Sophos Update Manager (SUM) list view, the errors corresponding to a SUM may be listed against another SUM, potentially flagging a working SUM as failing and vice versa.  The more SUMs you are managing the higher the chance of this issue occurring.

First seen in

Enterprise Console 4.5.0

Note: This issue is fixed in version 5.2.1 of Sophos Enterprise Console.

Cause

The database stored procedure 'ErrorLatestForComputerIDListGet' fails to order the computer ID list correctly.

What To Do

Update the stored procedure 'ErrorLatestForComputerIDListGet' in your database by running the appropriate SQL file below for your version of the console.

Important: 

  • It is strongly recommended before carrying out the following steps that you backup the Enterprise Console database before updating it.  Article 17323 has a list of databases names to console versions for reference.  If you are using Enterprise Console 5.0 or later you can use the tool BackupDataRestore as documented in article 114299, for other versions of Enterprise Console see article: 110380.
  • When upgrading to future versions prior to Enterprise Console 5.2.1 you will be required to perform this same procedure against the database associated with the new version installed.
  1. Close down any console that may be open.
  2. On the computer hosting the Sophos database, download the appropriate SQL file from the list below:
  3. Once downloaded remove the .txt extension to make it a .sql file.
  4. Execute the following command:
    sqlcmd -E -S (local)\sophos -i C:\SUMErrors[verion].sql

    Where:
    (local)\Sophos represents a local SQL Server instance called Sophos (this is the default instance name).
    The text: [version] should be updated to reflect the file name downloaded.

  5. Restart the service "Sophos Management Service". (Start | Run | Type: services.msc | Press return).
  6. Re-launch the console, check the SUM list view to confirm the issue has been resolved.

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

Rate this article

Very poor Excellent

Comments