SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 14238: Web Report Studio may cause the Stored Process Server to "hang"

DetailsHotfixAboutRate It
When submitting requests to the Stored Process Server, Web Report Studio
may cause the Stored Process Server to hang.

Web Report Studio opens connections to the Stored Process Server but
does not free the server connections.  The default configuration of the
Stored Process Server permits up to twelve connections.  So, once these
twelve connections have been used (and not freed), no more connections
are available.  The connections are freed when Web Report Studio is
closed.

The following scenario may cause the Stored Process Server to hang:

   1.) In Web Report Studio, go to:
       Shared Folders -> Reports -> StoredProcesses

   2.) Run 'tsttabu2'
       See the expected prompts window; leave default as 'activex'
       and  select 'View Report' to see the report.

   3.) Repeat the following two steps until it hangs.  It
       may take about eight iterations

       A. Select "Refresh Data."  This will take you
          back to the prompts window

       B. Select "View Report" to see the report.

The following error message may be displayed when this problem occurs:

   sam.S251.ex.msg: A problem occurred while connecting to a load
   balancing spawner. Check the spawner log for more details.

A Hot fix is available in SAS 9.1.3 SP2.  Web Report Studio is
re-released in the SP2 service pack.  So, users will need to install the
new WRS Version 2.1 to fix this problem.

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#014238

For customers running SAS with Asian Language Support (DBCS), this
fix should be downloaded from:

http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#014238


Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS Integration TechnologiesMicrosoft Windows XP Professional9.1 TS1M39.1 TS1M3 SP2
Microsoft Windows Server 2003 Standard Edition9.1 TS1M39.1 TS1M3 SP2
Microsoft® Windows® for 64-Bit Itanium-based Systems9.1 TS1M39.1 TS1M3 SP2
Microsoft Windows Server 2003 Datacenter Edition9.1 TS1M39.1 TS1M3 SP2
Microsoft Windows Server 2003 Enterprise Edition9.1 TS1M39.1 TS1M3 SP2
Microsoft Windows 2000 Server9.1 TS1M39.1 TS1M3 SP2
Microsoft Windows 2000 Professional9.1 TS1M39.1 TS1M3 SP2
Microsoft Windows 2000 Datacenter Server9.1 TS1M39.1 TS1M3 SP2
64-bit Enabled Solaris9.1 TS1M39.1 TS1M3 SP2
Microsoft Windows 2000 Advanced Server9.1 TS1M39.1 TS1M3 SP2
z/OS9.1 TS1M39.1 TS1M3 SP2
Linux9.1 TS1M39.1 TS1M3 SP2
Linux on Itanium9.1 TS1M39.1 TS1M3 SP2
OpenVMS Alpha9.1 TS1M39.1 TS1M3 SP2
HP-UX IPF9.1 TS1M39.1 TS1M3 SP2
64-bit Enabled HP-UX9.1 TS1M39.1 TS1M3 SP2
Microsoft Windows NT Workstation9.1 TS1M39.1 TS1M3 SP2
64-bit Enabled AIX9.1 TS1M39.1 TS1M3 SP2
Tru64 UNIX9.1 TS1M39.1 TS1M3 SP2
* 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.