Problem Note 57043: Macro variables SYSRC, SYSERR, and SQLRC are not being set when "Error on server LIBNAME socket" occurs on the SAS® Scalable Performance Data Server
The macro variables SYSRC, SYSERR, and SQLRC are not being set when "Error on server LIBNAME socket" occurs.
The example code below shows both the error in the SAS log and the macro variables SYSRC, SYSERR, and SQLRC incorrectly being set to zero.
50 proc sql;
51 create table members as
52 select *
53 from dictionary.tables
54 where libname ='FOO';
ERROR: Error on server LIBNAME socket.
55 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 5.08 seconds
cpu time 0.10 seconds
56 %put SYSRC=&SYSRC SYSERR=&SYSERR SQLRC=&SQLRC SQLOBS=&SQLOBS
SYSERRORTEXT=&SYSERRORTEXT;
SYSRC=0 SYSERR=0 SQLRC=0 SQLOBS=7 SYSERRORTEXT=Error on server LIBNAME socket.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | Base SAS | Microsoft® Windows® for x64 | 9.4_M2 | 9.4_M3 | 9.4 TS1M2 | 9.4 TS1M3 |
Microsoft Windows Server 2012 Datacenter | 9.4_M2 | 9.4_M3 | 9.4 TS1M2 | 9.4 TS1M3 |
Microsoft Windows Server 2012 R2 Datacenter | 9.4_M2 | 9.4_M3 | 9.4 TS1M2 | 9.4 TS1M3 |
Microsoft Windows Server 2012 R2 Std | 9.4_M2 | 9.4_M3 | 9.4 TS1M2 | 9.4 TS1M3 |
Microsoft Windows Server 2012 Std | 9.4_M2 | 9.4_M3 | 9.4 TS1M2 | 9.4 TS1M3 |
Windows 7 Enterprise x64 | 9.4_M2 | 9.4_M3 | 9.4 TS1M2 | 9.4 TS1M3 |
Windows 7 Professional x64 | 9.4_M2 | 9.4_M3 | 9.4 TS1M2 | 9.4 TS1M3 |
64-bit Enabled AIX | 9.4_M2 | 9.4_M3 | 9.4 TS1M2 | 9.4 TS1M3 |
64-bit Enabled Solaris | 9.4_M2 | 9.4_M3 | 9.4 TS1M2 | 9.4 TS1M3 |
HP-UX IPF | 9.4_M2 | 9.4_M3 | 9.4 TS1M2 | 9.4 TS1M3 |
Linux for x64 | 9.4_M2 | 9.4_M3 | 9.4 TS1M2 | 9.4 TS1M3 |
Solaris for x64 | 9.4_M2 | 9.4_M3 | 9.4 TS1M2 | 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.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2016-04-07 15:01:26 |
Date Created: | 2015-11-10 09:28:56 |