The code in the Full Code tab in this Problem Note produces the following message in the SAS log file:

 SPDS_ERROR: Parallel Join: Thread initialization error, Plljoin Aborted

Select the Hot Fix tab in this Note to access the latest maintenance release for the version of SPD Server you are currently running.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SPDS	Scalable Performance Data Server	Microsoft Windows Server 2003 Datacenter 64-bit Edition	4.52 HF4	4.52 HF5
		Microsoft Windows Server 2003 Enterprise 64-bit Edition	4.52 HF4	4.52 HF5
		Microsoft® Windows® for x64	4.52 HF4	4.52 HF5
		Microsoft Windows Server 2003 Datacenter Edition	4.52 HF4	4.52 HF5
		Microsoft Windows Server 2003 Enterprise Edition	4.52 HF4	4.52 HF5
		Microsoft Windows Server 2003 Standard Edition	4.52 HF4	4.52 HF5
		Microsoft Windows XP Professional	4.52 HF4	4.52 HF5
		64-bit Enabled AIX	4.52 HF4	4.52 HF5
		64-bit Enabled HP-UX	4.52 HF4	4.52 HF5
		64-bit Enabled Solaris	4.52 HF4	4.52 HF5
		Linux for x64	4.52 HF4	4.52 HF5
		Solaris for x64	4.52 HF4	4.52 HF5

* 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.

The following code assumes you have LIBNAME domain TMP defined in LIBNAMES.PARM file and SPD Name Server is listening on port 5400.

---

libname spdslib sasspds 'tmp' server=localhost.5400 user='anonymous' libgen=yes ip=yes;

data spdslib.plljn1;
input BND_ID;
cards;
2
3
4
;
run;

data spdslib.plljn2;
input BND_ID DLKEY $;
cards;
2 abcd
3 abcd
4 abcde
;
run;


proc sql;
          create view work.T1 as
             select
                BND_ID,
                DLKEY
          from  spdslib.plljn2
          ;
                quit;

                proc sql;

          create view work.T2 as
             select
                BND_ID
          from spdslib.plljn1
          ;

                  quit;

proc sql;
   create view work.T3 as
   select
      T1.DLKEY, T1.BND_ID, T2.BND_ID
   from
      work.T1 left join
      work.T2
         on
         (
            T1.BND_ID = T2.BND_ID
         )
   ;
quit;


data _null_;
      dsid = open("work.T3");
run;

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#44012

---

A 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#44012

---

Apply the latest maintenance to solve this problem.

Type:	Problem Note
Priority:	high
Topic:	System Administration ==> Servers ==> SPDS

Date Modified:	2011-08-23 11:26:07
Date Created:	2011-08-16 04:00:55