Hotfix package name: ES540ServerWX64005.zip
For: EdgeSight Servers running on 64-bit editions of one of the following operating systems, with or without EdgeSight software being previously installed:

• Windows Server 2008 R2
• Windows Server 2008
• Windows Server 2003 SP1 or later

Replaces: All previous versions
Date: September, 2015
Languages supported: English (US), German (DE), Spanish (ES), French (FR), Japanese (JA)
Readme version: 1.00

Readme Revision History

Version	Date	Change Description
1.00	September, 2015	Initial release

Important Note(s)

• If your SQL database is mirrored, disable the mirroring before you perform this upgrade. After the upgrade, you can restore the SQL server to the normal configuration. See Knowledge Center article CTX138637 for details.
• Caution! This release may require you to edit the registry. Using Registry Editor incorrectly can cause serious problems that may require you to reinstall your operating system. Citrix cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

Where to Find Documentation

This document describes the issue(s) resolved by this release and includes installation instructions. For additional product information, see EdgeSight 5.4 on the Citrix Product Documentation site.

New Fixes in This Release

1.     The Environment Usage report shows duplicate processes when different paths exist for the same process.

[From ES540ServerWX64005][#LC2225]

Fixes from Replaced Hotfixes

1.     Uploading the payload results in the following error message due to the violation of primary key constraint:

"Cannot insert duplicate key in object 'dbo.ctrx_session_autoreconnect'."

[From ES540ServerWX64001][#238149]

2.     When Worker 101 (Performance Upload) and Worker 2 (Database Maintenance) run at the same time, an upload is attempted even though the database is not available. Although the status of Worker 101 is displayed as successful, this situation results in the following payload error:

"Invalid payload, no ENV data found"

[From ES540ServerWX64001][#242200]

3.     When exporting the Session Counts report to Microsoft Excel, the exported data displays "#Value!" in the peak columns.

[From ES540ServerWX64001][#253058]

4.     If multiple users connect to different XenApp servers and are assigned the same session id by the terminal server, the payload from one XenApp Server can overwrite the principal id of the other XenApp Server, resulting in incorrect EdgeSight report data.

[From ES540ServerWX64001][#253168]

5.     Users can run the "Assets for a Device" report against devices for which they do not have user permissions.

[From ES540ServerWX64001][#256871]

6.     If the initial attempt to upgrade a server from EdgeSight Version 5.2 to Version 5.3 or later fails, an error might occur when making subsequent upgrade attempts. The following error message appears in the MSI log:

"Error -2147217900: failed to execute SQL string, error detail: Ambiguous column name 'appid'., SQL key: SchemaPost530"

[From ES540ServerWX64001][#LA0402]

7.     Running any of the following reports on Version 5.4 of EdgeSight Web server (Version 5.4.0.5107 or earlier) in the EdgeSight database might generate errors messages:

·         Process Errors

·         Process Errors for a User Group

·         Process Faults

·         Process Faults for a User Group

The following error messages are observed:

·         An error occurred during the client rendering

·         An error has occurred during the report processing (rsProcessingAborted)

·         Cannot read the next data row for the dataset edgesight (rserrorreadingnextdatarow)

·         Arithmetic over flow error converting expression to data type int

This occurs when the ID generated by the alert table (alert ID) exceeds the maximum integer value (2147483648).

[From ES540ServerWX64001][#LA0760]

8.     If you change user names in Active Directory, the changes are not reflected in the EdgeSight database.

[From ES540ServerWX64002][#LA1243]

9.     You can only view one time zone entry in the EdgeSight database when setting the time zone for the Venezula cities Carcas and LaPaz.

[From ES540ServerWX64002][#LA1378]

10.  For computers running the French language Windows operating system, the available free memory alert might not display correctly. This occurs when using the space character as a Digit Grouping Symbol which results in the incorrect decoding of the digit group separator space.

[From ES540ServerWX64002][#LA1807]

11.  The "Published Application Picker" might display duplicate entries for the same published application when the system is not selected. For example, when a single published application is published on two different servers that are connected to the EdgeSight server, the "Published Application Picker" might display two entries for the same published application for each server.

[From ES540ServerWX64002][#LA1893]

12.  Clearing the "Add a file extension when the file is created" option while updating the subscription might result in the following null reference exception:

"Error: System.NullReferenceException: Object reference not set to an instance of an object."

[From ES540ServerWX64002][#LA2199]

13.  The "User Troubleshooter" report in Troubleshooter tab of the EdgeSight Server Console might display the following error message:

"Real Time Information is unavailable.
The connection to the remote Citrix System Monitoring Agent database has timed out. The connection has been closed."

The issue occurs because the data is not retrieved before the default connection time-out value (five seconds) of the Troubleshooter.

To enable a different timeout, create the following key in the [appSettings] section of the web.config file:
<appSettings>
<add key="RealTimeConnTimeOut" value="11"/>
</appSettings>

Note: Due to preexisting configuration or the workaround described in Knowledge Center article CTX132116, additional keys may already exist in that section, "<appSettings> <add key..> <add key..> <add key..> </appSettings>".

For example, the [appSettings] section can be configured as follows:
<appSettings>
<add key="RealTimeConnTimeOut" value="11"/>
<add key="aspnet:MaxHttpCollectionKeys" value="80000"/>
</appSettings>

The web.config file is located in the following location %ProgramFiles(x86)%\Citrix\System Monitoring\Server\EdgeSight\Pages folder on the EdgeSight server.

Before editing the web.config file, create a copy of the file and rename it web.config.pre-KB2661403.

[From ES540ServerWX64002][#LA2217]

14.  Real-time reports using Microsoft Excel might fail if Excel application add-ins are configured to be signed by a trusted publisher. This happens when the certificate used to digitally sign macros in Excel expires.

[From ES540ServerWX64002][#LA2541]

15.  The payload might fail to load to the EdgeSight server with a system overflow exception error referencing the column i23 value to be either too large or too small for an Int32.

[From ES540ServerWX64002][#LA2670]

16.  If the first name of the EdgeSight administrator account contains only numeric values, login attempts to the EdgeSight Server Console might fail.

[From ES540ServerWX64002][#LA3115]

17.  The Session Started and Session Ended columns of Published Application Launch Count reports for a user group display identical values.

[From ES540ServerWX64002][#LA3167]

18.  Clicking links in Excel files exported from EdgeSight reports might not open the expected EdgeSight console Web page.

[From ES540ServerWX64003][#LA2238]

19.  Data upload and grooming for the Process Usage report might not be available. The issue occurs when the Agent Support setting for EdgeSight for XenApp support is set to On – Basic Agents Only.

[From ES540ServerWX64003][#LA3442]

20.  The EdgeSight Device Troubleshooter feature might display the following error messages:

·         "Real time information is unavailable. Operation is not allowed when the object is closed."

·         "Real time information is unavailable. The connection to the remote Citrix System Monitoring Agent database has timed out. The connection has been closed."

This fix allows you to modify the default time-out value (five seconds) in the web.config file. To do this, add the following entry to the [appSettings] section of the web.config fle:
<appSettings>
<add key="RealTimeConnTimeOut" value="11"/>
</appSettings>

Note: Due to preexisting configuration or the workaround described in Knowledge Center article CTX132116, additional keys may already exist in that section, "<appSettings> <add key..> <add key..> <add key..> </appSettings>".

For example, the [appSettings] section can be configured as follows:
<appSettings>
<add key="RealTimeConnTimeOut" value="11"/>
<add key="aspnet:MaxHttpCollectionKeys" value="80000"/>
</appSettings>

The web.config file is located in the following location %ProgramFiles(x86)%\Citrix\System Monitoring\Server\EdgeSight\Pages folder on the EdgeSight server.

Important: Before editing the web.config file, create a copy of the file and rename it web.config.pre-KB2661403.

[From ES540ServerWX64003][#LA3555]

21.  When requesting Stability data, the Device Troubleshooter report on the Troubleshooter tab of the EdgeSight Server Console might display the following error message:

"Real Time Information is unavailable.
The connection to the remote Citrix System Monitoring Agent database has timed out. The connection has been closed."

The issue is caused by mishandled stability data returned by the agent.

[From ES540ServerWX64003][#LA4217]

22.  When the Device Troubleshooter feature encounters a timeout error, the error might be displayed again during revisits to the device until another activity is invoked. With this fix, clicking Go properly refreshes the data.

[From ES540ServerWX64003][#LA4218]

23.  The CPU Utilization Management Report displays data for the published applications but not for published desktops.

To enable the fix, you must load the new reports as follows:

1.     On the Configure tab, navigate to Server Configuration > Reporting Services > Report Server > Operations tab.

2.     On the Operations tab, select  Load Report.

3.     Click Execute.

[From ES540ServerWX64003][#LA4537]

24.  The application count is too high in the "Published Application Launch report."

[From ES540ServerWX64004][#LA4876]

25.  If a metric does not have data, the legend does not appear in the Dashboard.

[From ES540ServerWX64004][#LA5066]

26.  When you find a user session by using the User Troubleshooter > Find Sessions option, if the user name contains a pound or hash (#) sign, the error message "An error occured querying server of farm: value does not fall within the expected range" appears.

[From ES540ServerWX64004][#LA5439]

27.  The EdgeSight administrator receives an email notification about the payload processing error related to "Violation of PRIMARY KEY constraint 'PK_ctrx_service_state'".

[From ES540ServerWX64004][#LC0486]

28.  If a published application map contains duplicates, the "Session Client Startup Duration" report might experience a long run time or can time-out.

[From ES540ServerWX64004][#LC0571]

29.  The EdgeSight web console supports Internet Explorer 11. To use EdgeSight Reports and to view the report toolbar correctly, you need to use compatability mode. For more information, see Knowledge Center article CTX200056.

[From ES540ServerWX64004][#LC0992]

30.  This release includes new certificates for binaries and Excel reports.

[From ES540ServerWX64004][#LC1088]

31.  Hash marks, instead of text, appears on the Y axis in the reports "Published Application Count - detail" and "Published Application User Count - Details."

[From ES540ServerWX64004][#LC1331]

Installing This Release

Notes:

• Important: If your SQL database is mirrored, disable the mirroring before you perform this upgrade. After the upgrade, you can restore the SQL server to the normal configuration. See Knowledge Center article CTX138637 for details.
• This version is packaged as a .zip file containing the replacement EdgeSightServerx64.msi file and Setup.exe file. For more information about deploying msi files, see Microsoft article 884016 or visit the Microsoft Web site and search on keyword msiexec.
• To install this version successfully, servers must not have registry modification restrictions in place.

To install this version:

1.     Copy the file to a shared folder on the network.

2.     Extract the compressed file and save the EdgeSightServerx64.msi file and Setup.exe file on the computer you want to update.

3.     Run the Setup.exe file.

4.     Restart the computer if prompted to do so.

If it does not exist already, this will add a new entry, Citrix EdgeSight Server 5.4, to the Add/Remove Programs list.