Using the SAS^® Scalable Performance Data Server to perform an SQL procedure might cause SQL pass-through errors. The problem occurs if the procedure:

• contains a SELECT DISTINCT statement that contains numeric variables with a length of less than 8
• and it is performed in conjunction with a large SORTSIZE= value.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SPDS	Scalable Performance Data Server	Solaris for x64	4.53	5.2 HF1		9.4 TS1M3
		Linux for x64	4.53	5.2 HF1		9.4 TS1M3
		HP-UX IPF	4.53	5.2 HF1		9.4 TS1M3
		64-bit Enabled Solaris	4.53	5.2 HF1		9.4 TS1M3
		64-bit Enabled HP-UX	4.53	5.2 HF1		9.4 TS1M3
		64-bit Enabled AIX	4.53	5.2 HF1		9.4 TS1M3
		Microsoft Windows Server 2008 for x64	4.53	5.2 HF1		9.4 TS1M3
		Microsoft Windows 8.1 Enterprise x64	4.53	5.2 HF1		9.4 TS1M3
		Microsoft Windows 8 Enterprise x64	4.53	5.2 HF1		9.4 TS1M3
		Microsoft® Windows® for x64	4.53	5.2 HF1		9.4 TS1M3

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

---

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

https://tshf.sas.com/techsup/download/hotfix/HF2/U88.html#56146

---

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

https://tshf.sas.com/techsup/download/hotfix/HF2/N49.html#56146

---

"SPDS_ERROR: SQL passthru expression contained errors" and "ERROR: SPDS Sql Passthru Error" occur when you issue a PROC SQL query with a SELECT DISTINCT. The issue occurs when a numeric variable is fewer than 8 bytes and the procedure is performed in conjunction with a large SORTSIZE= value.

Type:	Problem Note
Priority:	medium

Date Modified:	2015-07-15 12:06:12
Date Created:	2015-07-09 14:01:26