If a SAS^® Stored Process contains a dynamic prompt and the SAS Stored Process is executed in more than 10 Web browser sessions within a short period of time, this might cause performance problems for the SAS Pooled Workspace Server.

The SAS Object Spawner might attempt to bring up a new SAS Pooled Workspace Server each time a new request is submitted in a new Web browser session. The connection to the SAS Pooled Workspace Server might not be released until the request connection times out. The default timeout for an inactive process is 10 minutes.

The following approach should illustrate the problem.

1. Create a SAS Stored Process that has a dynamic prompt.
2. Bring up a Web browser and run the SAS Stored Process using the SAS Stored Process Web Application.
3. Shut down the Web browser.
4. Repeat Step 2 and Step 3 above 10 times.

   When you attempt to run the SAS Stored Process the 11th time, the dynamic prompt might not be displayed.

The SAS Pooled Workspace Server connections should be released when the Inactive process shutdown timeout occurs. By default, the Inactive process shutdown timeout is 600 seconds (10 minutes).

If you encounter this problem, it should be helpful to increase the Server process maximum for the SAS Pooled Workspace Server by following these steps:

1. Using SAS^® Management Console, select:

   ► SASApp - Pooled Workspace Server ► Options (tab) ► Advanced Options (button) ► Load Balancing (tab)

2. On the Load Balancing tab in the Advanced Options window, increase the Server process maximum value. The default value is 10.

This problem should not occur if you run the SAS Stored Process using SAS^® Enterprise Guide^® because SAS Enterprise Guide uses the standard SAS Workspace Server for dynamic prompts instead of the SAS Pooled Workspace Server.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Integration Technologies	z/OS	9.2_M1	9.3_M1	9.2 TS2M3	9.3 TS1M1
		Microsoft® Windows® for 64-Bit Itanium-based Systems	9.2_M1	9.3_M1	9.2 TS2M3	9.3 TS1M1
		Microsoft Windows Server 2003 Datacenter 64-bit Edition	9.2_M1	9.3_M1	9.2 TS2M3	9.3 TS1M1
		Microsoft Windows Server 2003 Enterprise 64-bit Edition	9.2_M1	9.3_M1	9.2 TS2M3	9.3 TS1M1
		Microsoft Windows XP 64-bit Edition	9.2_M1	9.3_M1	9.2 TS2M3	9.3 TS1M1
		Microsoft® Windows® for x64	9.2_M1	9.3_M1	9.2 TS2M3	9.3 TS1M1
		Microsoft Windows Server 2003 Datacenter Edition	9.2_M1	9.3_M1	9.2 TS2M3	9.3 TS1M1
		Microsoft Windows Server 2003 Enterprise Edition	9.2_M1	9.3_M1	9.2 TS2M3	9.3 TS1M1
		Microsoft Windows Server 2003 Standard Edition	9.2_M1	9.3_M1	9.2 TS2M3	9.3 TS1M1
		Microsoft Windows Server 2003 for x64	9.2_M1	9.3_M1	9.2 TS2M3	9.3 TS1M1
		Microsoft Windows Server 2008	9.2_M1	9.3_M1	9.2 TS2M3	9.3 TS1M1
		Microsoft Windows Server 2008 for x64	9.2_M1	9.3_M1	9.2 TS2M3	9.3 TS1M1
		Microsoft Windows XP Professional	9.2_M1	9.3_M1	9.2 TS2M3	9.3 TS1M1
		Windows 7 Enterprise 32 bit	9.2_M1	9.3_M1	9.2 TS2M3	9.3 TS1M1
		Windows 7 Enterprise x64	9.2_M1	9.3_M1	9.2 TS2M3	9.3 TS1M1
		Windows 7 Home Premium 32 bit	9.2_M1	9.3_M1	9.2 TS2M3	9.3 TS1M1
		Windows 7 Home Premium x64	9.2_M1	9.3_M1	9.2 TS2M3	9.3 TS1M1
		Windows 7 Professional 32 bit	9.2_M1	9.3_M1	9.2 TS2M3	9.3 TS1M1
		Windows 7 Professional x64	9.2_M1	9.3_M1	9.2 TS2M3	9.3 TS1M1
		Windows 7 Ultimate 32 bit	9.2_M1	9.3_M1	9.2 TS2M3	9.3 TS1M1
		Windows 7 Ultimate x64	9.2_M1	9.3_M1	9.2 TS2M3	9.3 TS1M1
		Windows Vista	9.2_M1	9.3_M1	9.2 TS2M3	9.3 TS1M1
		Windows Vista for x64	9.2_M1	9.3_M1	9.2 TS2M3	9.3 TS1M1
		64-bit Enabled AIX	9.2_M1	9.3_M1	9.2 TS2M3	9.3 TS1M1
		64-bit Enabled HP-UX	9.2_M1	9.3_M1	9.2 TS2M3	9.3 TS1M1
		64-bit Enabled Solaris	9.2_M1	9.3_M1	9.2 TS2M3	9.3 TS1M1
		HP-UX IPF	9.2_M1	9.3_M1	9.2 TS2M3	9.3 TS1M1
		Linux	9.2_M1	9.3_M1	9.2 TS2M3	9.3 TS1M1
		Linux for x64	9.2_M1	9.3_M1	9.2 TS2M3	9.3 TS1M1
		OpenVMS on HP Integrity	9.2_M1	9.3_M1	9.2 TS2M3	9.3 TS1M1
		Solaris for x64	9.2_M1	9.3_M1	9.2 TS2M3	9.3 TS1M1

* 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 Middle Tier 9.2_M2 is available at:

http://ftp.sas.com/techsup/download/hotfix/HF2/C80.html#44804

---

A fix for this issue for SAS Management Console 9.3 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/E90.html#44804

---

A fix for this issue for SAS Middle Tier 9.3_M1 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/G38.html#44804

---

If a SAS® Stored Process contains a dynamic prompt and the SAS Stored Process is executed in more than 10 Web browser sessions within a short period of time, this might cause performance problems for the SAS Pooled Workspace Server.

Type:	Problem Note
Priority:	high

Date Modified:	2012-11-27 11:21:22
Date Created:	2011-11-04 15:59:47