If you execute a parallel JOIN with SAS® Scalable Performance Data Server and you have multiple JOIN variables, and if the order of the JOIN variables listed on the EQUIJOIN predicate is different from the order of the variables listed on the FROM cause, you may receive a "broken pipe" error.

Here is an example of code that will cause the error:

PROC SQL;
CREATE TABLE WORK.VIEW3 AS
        SELECT SUM(table1.CONTACTCONF) AS CONTACTCONF LABEL='Contactconf'
        FORMAT=F20.5,
                    table0.HHID AS HHID LABEL='Hhid' FORMAT=F10.0
        FROM        MAFSSPDS.HH1 table0
        Inner join  MAFSSPDS.CUSTOMER1 table1
        on          table1.HHID = table0.HHID
        and         table1.HHID = table0.HHID
        GROUP BY 2 ;
QUIT;

In the example code, the FROM clause order is table0 following by table1, but there are multiple variables on the EQUIJOIN clause, and the order of the variables is table1.HHID = table0.HHID. This results in table1 being accessed before table0, and it causes the "broken pipe" error.

Operating System and Release Information

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

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