Problem Note 43945: Long table name in SQL JOIN might cause SAS® Scalable Performance Data Server® to disconnect in a Windows environment
 |  |  |  |  |  |
The code found in the Full Code tab in this Problem Note may cause SPD Server to disconnect and produces the following message in the SAS® log file:
NOTE: Implicit SQL: select a.xyz123456 from VERYLONGLONGLONGLONGLONGTABLE_A a,
VERYLONGLONGLONGLONGLONGTABLE_B b where a.xyz123456 = b.xyz123456
ERROR: ERROR: Server has disconnected..
ERROR: Error on server LIBNAME socket.
ERROR: ERROR: Server has disconnected..
ERROR: 10053 - WSAECONNABORTED.
The problem is observed when SAS Scalable Performance Data Server is running in a Windows environment.
Select the Hot Fix tab in this note to access the hot fix for this problem.
This problem is also fixed in SAS® Scalable Performance Data Server® 4.4TSM14.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SPDS | Scalable Performance Data Server | Microsoft Windows XP 64-bit Edition | 4.52 HF2 | 4.52 HF5 | ||
| Microsoft® Windows® for x64 | 4.52 HF2 | 4.52 HF5 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 4.52 HF2 | 4.52 HF5 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 4.52 HF2 | 4.52 HF5 | ||||
| Microsoft Windows Server 2003 Standard Edition | 4.52 HF2 | 4.52 HF5 | ||||
| Microsoft Windows XP Professional | 4.52 HF2 | 4.52 HF5 | ||||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 4.52 HF2 | 4.52 HF5 | ||||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 4.52 HF2 | 4.52 HF5 | ||||
The following code assumes you have LIBNAME domain TMP defined in LIBNAMES.PARM file and SPD Name Server is listening on port 5400.
libname spds sasspds 'tmp' server=localhost.5400 user='anonymous' IP=YES LIBGEN=YES;
data spds.verylonglonglonglonglongtable_A;
xyz123456=1;
output;
run;
data spds.verylonglonglonglonglongtable_B;
xyz123456=1;
output;
run;
proc sql;
create table spds.table_AB as
select a.* from spds.verylonglonglonglonglongtable_A a, spds.verylonglonglonglonglongtable_B b
where a.xyz123456=b.xyz123456;
quit;
A fix for this issue for Scalable Performance Data Server 4.52 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/B57.html#43945A fix for this issue for SAS Scalable Performance Data Server 4.53 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/F61.html#43945A fix for this issue for SPD Server 4.4 is available at:
http://www.sas.com/techsup/download/hotfix/spds44.html#043945| Type: | Problem Note |
| Priority: | high |
| Topic: | System Administration ==> Servers ==> SPDS |
| Date Modified: | 2011-08-12 19:30:43 |
| Date Created: | 2011-08-09 08:13:28 |