This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How to acknowledge error Sophos AutoUpdate error 0x0000004B

Looks like this error can't be cleared - doesn't show in the Acknowledge alerts and errors. And no article for it is available.

Christian

:934


This thread was automatically locked due to age.
Parents
  • Hi again,

    "Hi (how should I address you),"  I go by Ian.

    Unfortunately, I feel your pain on the cryptic hex errors. My personal favorite are the event decode errors.

    As for the cleanup, I came by a script to purge update errors, but it also purges SAV and SCF.

    This script is for EC3.1 (db name Sophos3 etc...). Haven't had the need to use it on EC4. 

    Be sure to replace ####InstanceName### with the appropriate database instance name. 

    And of course, use at your own risk etc..., I wouldn't normally share a script that modifies a database, but I can see that you know what you are doing.

    Begin script:

    cls

    @echo off
    Echo.
    echo This program will purge all false update alert data from the database.
    echo Please wait for this script to complete before opening up the console.
    echo.
    pause
    cls
    REM clearing the main database
    REM clear autoupdate, SAV, SCF errors
    osql -E -S ##InstanceName### -d sophos3 -Q "delete from errors where source = 'ALC'"
    REM Reseting console status
    REM Clears SAV errors status from machine information
    osql -S ##InstanceName### -E -d SOPHOS3 -Q "update ComputersAndDeletedComputers set LastAUErrorAlert = null"
    :Enddatabasecorrection
    cls
    @echo off
    echo The script has now completed clearing Sau alerts database
    echo.
    pause
    goto exit
    :exit

    -ian

    :1266
Reply
  • Hi again,

    "Hi (how should I address you),"  I go by Ian.

    Unfortunately, I feel your pain on the cryptic hex errors. My personal favorite are the event decode errors.

    As for the cleanup, I came by a script to purge update errors, but it also purges SAV and SCF.

    This script is for EC3.1 (db name Sophos3 etc...). Haven't had the need to use it on EC4. 

    Be sure to replace ####InstanceName### with the appropriate database instance name. 

    And of course, use at your own risk etc..., I wouldn't normally share a script that modifies a database, but I can see that you know what you are doing.

    Begin script:

    cls

    @echo off
    Echo.
    echo This program will purge all false update alert data from the database.
    echo Please wait for this script to complete before opening up the console.
    echo.
    pause
    cls
    REM clearing the main database
    REM clear autoupdate, SAV, SCF errors
    osql -E -S ##InstanceName### -d sophos3 -Q "delete from errors where source = 'ALC'"
    REM Reseting console status
    REM Clears SAV errors status from machine information
    osql -S ##InstanceName### -E -d SOPHOS3 -Q "update ComputersAndDeletedComputers set LastAUErrorAlert = null"
    :Enddatabasecorrection
    cls
    @echo off
    echo The script has now completed clearing Sau alerts database
    echo.
    pause
    goto exit
    :exit

    -ian

    :1266
Children
No Data