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

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:

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