Problem Note 44804: Using a SAS® Stored Process dynamic prompt might cause performance problems for the SAS Pooled Workspace Server
 |  |  |  |  |
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.
- Create a SAS Stored Process that has a dynamic prompt.
- Bring up a Web browser and run the SAS Stored Process using the SAS Stored Process Web Application.
- Shut down the Web browser.
- 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:
-
Using SAS® Management Console, select:
► SASApp - Pooled Workspace Server ► Options (tab) ► Advanced Options (button) ► Load Balancing (tab)
- 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 | ||