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

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:

A fix for this issue for SAS Scalable Performance Data Server 4.53 is available at:

A fix for this issue for SPD Server 4.4 is available at: