FIX: ISA Reports May Contain Negative Numbers in the 'All Others' Row

When you view HTML reports, Internet Security and Acceleration (ISA) Server report may show large negative numbers in the All Others row and percentage numbers that do not add up to 100 percent. The report may also include rows with duplicate key names. This may occur when you view reports that are generated from monthly or yearly summary files. Reports that are generated from daily summary files do not have the problem. The default number of daily summaries saved is 36.

During the multiplexing of daily summaries into one monthly summary file or of monthly summaries into a yearly summary file, ISA may sort the tables incorrectly if the active locale is one of the following:

• Danish
• Norwegian (Bokmal)
• Norwegian (Nynorsk)

For strings in these locales, the character "aa" is interpreted as the accented character "å". Because this letter comes after "z" in the alphabet, a locale-dependent string comparison function may break the sorting algorithm and include multiple rows with the same name. When a report is then created, the report (.irp) file may include multiple rows with the same name, including the Total row. If multiple Total rows exist, ISA may calculate the percentage numbers incorrectly and show negative numbers in the All Others row.

The string comparison function is dependent on the active locale that is running on the system. By default, this is the SYSTEM locale if no one has logged on to the computer, or it is the locale of the user that last logged on to the system. You can set the SYSTEM locale to another locale, but this may not be enough because the active locale may change when a user logs on.

With the hotfix installed, the sorting algorithm is not affected by the active locale, and summary files are generated correctly.

Note The hotfix only fixes monthly or yearly summary files that are generated after the hotfix has been installed. Old monthly and yearly summary files may still have tables with multiple key rows.

A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem.

If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, submit a request to Microsoft Customer Service and Support to obtain the hotfix.

Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site: Note The "Hotfix download available" form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language. The English version of this fix has the file attributes (or later) that are listed in the following table. The dates and times for these files are listed in coordinated universal time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel. This fix also applies to the French, German, Spanish, and Japanese versions of ISA Server.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.