If you have a SAS® Scalable Performance Data Server CLUSTER table as a DIMENSION table, and the CLUSTER table does not have a unique index, the STAR JOIN optimization fails with the following error message:

   SPDS_ERROR: STARJOIN: Error generated 
   in /sas/dev/spds/ssql/src/sqlstarjoin.c at line 2649.
   SPDS_ERROR: SQL passthru expression contained errors. 

If you are running SAS Scalable Performance Data Server 4.4TSM11 or later with SAS 9.13, this problem has been corrected. A check is done to determine if the CLUSTER table has a unique index. It will also allow you to use a non-verified unique index for a CLUSTER table with the assumption that it is unique. However, you will receive the following message in your log file:

   USING NON-VERIFIED UNIQUE INDEX for CLUSTER 
   DIMENSION=<dimension_table_name> 

If you are running SAS Scalable Performance Data Server 4.5TSM2 or earlier with SAS 9.2, you must apply the hot fix to obtain the new functionality.

Operating System and Release Information

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

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