Known issue in HEAT EMSS 8.0-8.4: Upgrade fails with MigrateAVRecurringScanPolicies error in event log

Version 1

    Details

    This article describes a known issue in HEAT EMSS versions 8.0, 8.1, 8.2, 8.3, and 8.4.  HEAT software support and development are aware of this issue and looking to address it in a future update. The article includes a description of any known workaround and the currently planned release date of a solution. All release dates are subject to change without notice. We will update the article with the new release date where possible.


    Resolution

    Upgrading from an earlier release to any of these versions can produce this error in the Windows event log:

    ---------------------------------------------------
    Timestamp: 5/5/2016 12:14:38 PM
    Category: EventLog
    Brief:
    Message: SQL ERROR: Error occured while executing installer script: MigrateAVRecurringScanPolicies at step load reconfigured @value value Incorrect syntax near '<Exclusion Text>'.
    Priority: 0
    Severity: Error
    Machine: SERVERNAME
    Application Domain: LM.Logging.AppDomain
    Process Id: 3404
    Process Name: C:\Program Files (x86)\HEAT Software\EMSS\Install Manager\LM.EDS.exe
    Win32 Thread Id: 2552
    Thread Name:
    Extended Properties: source - DatabaseExecution
    ---------------------------------------------------

    NOTE:
    The text highlighted in red will vary based on the name of folder in your antivirus exclusion.

    This error is caused by AntiVirus exclusions that involve paths containing an apostrophe ( ' ) character.  Removing these exclusions before performing the upgrade will resolve the issue.  The exclusions may be added back after the upgrade has completed.

    This issue is under investigation by HEAT Software Development at this time.  A fix has not yet been scheduled.