Problem Note 56177: SAS® Scalable Performance Data Server disconnects and returns "ERROR: Error on server LIBNAME socket"
 |  |  |  |  |
An attempt to use WHERE constraints with a VIEW might cause SAS Scalable Performance Data Server to disconnect.
The problem occurs because WHERE constraints are not supported in a VIEW.
The error might look similar to the following:
14 proc spdo lib=foo;
NOTE: Enter "?;" to get info on all the SPDO commands.
Enter "SPDSMAC;" to get list and setting of all SPD macros.
15 set acluser;
NOTE: Acluser has been set to anonymou.
16 constraint remove _all_;
NOTE: Member does not exist in LIBNAME domain.
17 constraint add myview;
18 where x=1;
ERROR: .
ERROR: Error on server LIBNAME socket.
ERROR: .
ERROR: CONSTRAINT ADD did not complete.
19 quit;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 Client | Microsoft® Windows® for x64 | 5.1 HF3 | 5.1 HF4 | ||
| Microsoft Windows 8.1 Enterprise x64 | 5.1 HF3 | 5.1 HF4 | ||||
| Microsoft Windows Server 2008 for x64 | 5.1 HF3 | 5.1 HF4 | ||||
| Windows 7 Enterprise x64 | 5.1 HF3 | 5.1 HF4 | ||||
| 64-bit Enabled AIX | 5.1 HF3 | 5.1 HF4 | ||||
| 64-bit Enabled Solaris | 5.1 HF3 | 5.1 HF4 | ||||
| HP-UX IPF | 5.1 HF3 | 5.1 HF4 | ||||
| Linux for x64 | 5.1 HF3 | 5.1 HF4 | ||||
| Solaris for x64 | 5.1 HF3 | 5.1 HF4 | ||||
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#56177A 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#56177
When you use WHERE constraints with a VIEW in SAS Scalable Performance Data Server, the server disconnects. The issue occurs because WHERE constraints are not supported in a VIEW.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2015-07-21 16:06:00 |
| Date Created: | 2015-07-14 09:17:51 |