The SAS^® Visual Analytics Hyperlink Service, which evaluates conditions for alerts defined in SAS Visual Analytics reports, might create thousands of unclosed connections to the SAS^® Metadata Server. As a result, no other application can log on or create new connections. Restarting SASServer12 or the SAS Metadata Server helps for a short period.

When this problem exists, the SAS Metadata Server log contains a high number of lines like this one:

The log does not contain corresponding lines that indicate the CONNECTION_ID is closed.

This problem can occur when the user who created the alert is removed from the SAS Metadata Server. If you encounter this issue, contact SAS Technical Support for help with cleaning up the orphaned alerts.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Visual Analytics	Microsoft® Windows® for x64	7.5		9.4 TS1M6
		Linux for x64	7.5		9.4 TS1M6

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

A fix for this issue for SAS Visual Analytics 7.5 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/F9L.html#64841

---

The SAS® Visual Analytics Hyperlink Service, which evaluates conditions for alerts that are defined in SAS Visual Analytics reports, might create thousands of unclosed connections to the SAS® Metadata Server. As a result, no other application can log on or create new connections.

Type:	Problem Note
Priority:	medium

Date Modified:	2020-02-04 10:29:53
Date Created:	2019-09-27 04:39:15