Select Your Region
Americas
Europe
Middle East & Africa
Asia Pacific
SUPPORT / SAMPLES & SAS NOTES
Problem Note 57851: Sporadic "Access Violation" errors might occur when you use the Parallel Join facility with the SAS® Scalable Performance Data Server
 |  |  |  |  |
Using the Parallel Join facility with the SAS SPD Server might cause intermittent "Access Violation" error.
The problem occurs because a parallel join does multiple sorts of the table. When the parallel join determines that no more rows can come from the SQL join, it shuts down any parallel sorts that are still on-going. This causes an early termination of the merge logic for the parallel sort.
To circumvent the problem, disable the Parallel Join facility using one of the reset methods, as follows:
- In implicit pass-through:
%let SPDSSQLR= noplljoin; - In explicit pass-through:
execute(reset noplljoin) by sasspds;
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 | Linux for x64 | 5.1 HF4 | 5.1 HF5 | ||
| HP-UX IPF | 5.1 HF4 | 5.1 HF5 | ||||
| 64-bit Enabled Solaris | 5.1 HF4 | 5.1 HF5 | ||||
| 64-bit Enabled AIX | 5.1 HF4 | 5.1 HF5 | ||||
| Windows 7 Enterprise x64 | 5.1 HF4 | 5.1 HF5 | ||||
| Microsoft Windows Server 2008 for x64 | 5.1 HF4 | 5.1 HF5 | ||||
| Microsoft Windows Server 2003 for x64 | 5.1 HF4 | 5.1 HF5 | ||||
| Microsoft® Windows® for x64 | 5.1 HF4 | 5.1 HF5 | ||||
| Solaris for x64 | 5.1 HF4 | 5.1 HF5 | ||||