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
* 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.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 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#57851A 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#57851Type: Problem Note Priority: high Date Modified: 2016-03-30 13:55:01 Date Created: 2016-03-14 08:56:11 - In explicit pass-through: