The SAS Event Stream Processing Server (dfesp_xml_server) shows memory growth each time an event block is processed by the connector. Eventually, dfesp_xml_server can consume all the memory on the system, which causes the server to crash.  

This issue occurs because a SAS Event Stream Processing model uses a DB subscriber connector with an ODBC driver. The connector uses DRIVER=ODBC in the connectstring connector property. For example, the connector's connectstring connector property might be set as follows:

To work around this issue, recycle the ESP XML Server periodically to release the storage. This action stops all running models.

Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Event Stream Processing Engine	Microsoft® Windows® for x64	5.2	5.2
		Linux for x64	5.2	5.2
SAS System	SAS/ACCESS Interface to ODBC	Microsoft® Windows® for x64	V.03.04	V.03.04	Viya	Viya
		Linux for x64	V.03.04	V.03.04	Viya	Viya

* 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.

---

An update for this issue is available for SAS Viya 3.4. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.4 for Windows Deployment Guide at

http://documentation.sas.com/?softwareId=administration&softwareVersion=3.4&softwareContextId=softwareUpdatesWin

---

An update for this issue is available for SAS Viya 3.4. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.4 for Linux Deployment Guide at

http://documentation.sas.com/?softwareId=administration&softwareVersion=3.4&softwareContextId=softwareUpdates

---

Viya on Linux: An update for this issue is available for SAS Viya 3.4. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.4 for Linux Deployment Guide at

http://documentation.sas.com/?softwareId=administration&softwareVersion=3.4&softwareContextId=softwareUpdates

---

The SAS® Event Stream Processing Server (executable program name dfesp_xml_server) exhibits memory growth when you use a DB connector with an ODBC driver. In this scenario, the server eventually crashes.

Type:	Problem Note
Priority:	medium

Date Modified:	2019-05-29 13:50:15
Date Created:	2019-04-24 12:50:56