PurgeDB.exe fails to purge or delete SUM errors and alerts

  • Article ID: 109660
  • Rating:
  • 4 customers rated this article 2.5 out of 6
  • Updated: 09 May 2014


When attempting to "purge" or "delete" Sophos Update Manager (SUM) related errors or alerts, PurgeDB.exe always returns:

PurgeDB: 0 rows have been affected.

First seen in
Sophos Update Manager


In the "Errors" table of the SOPHOS4 database, the "Source" of messages from Sophos Update Manager (SUM) can be either "SDDMAlert" or "SDDM". PurgeDB.exe uses a config file called ActionMapping.xml to map the command line parameter values to those in the database.

For Example, the following command will clear an outstanding Migration Failed alert against all SUMs

purgedb -action=delete -category=errors -HistoryLengthInDays=0 -type=SUMAlert -code=-2147220444

However this passes on type=SUMAlert as the Source and therefore makes no matches in the database. The "What to do" section of this article corrects the mapping.

What To Do

Use the following workaround:
  1. Locate the file ActionMapping.xml in the directory "%programfiles%\sophos\enterprise console\" and make a backup of this file, e.g. ActionMapping.xml.orig.
  2. Open ActionMapping.xml in a text editor, for example Notepad.exe.
  3. Locate the lines:

    <Type name="SUM" value="SUM" />
    <Type name="SUMAlert" value="SUMALERT" />

    and update them to read:

    <Type name="SUM" value="SDDM" />
    <Type name="SUMAlert" value="SDDMALERT" />

  4. Save the file.
  5. Re-run the PurgeDB command you were executing.

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

Rate this article

Very poor Excellent