SUPPORT / SAMPLES & SAS NOTES
 

Support

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

DetailsHotfixAboutRate It

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

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemBase SASMicrosoft® Windows® for x649.4_M29.4_M39.4 TS1M29.4 TS1M3
Microsoft Windows Server 2012 Datacenter9.4_M29.4_M39.4 TS1M29.4 TS1M3
Microsoft Windows Server 2012 R2 Datacenter9.4_M29.4_M39.4 TS1M29.4 TS1M3
Microsoft Windows Server 2012 R2 Std9.4_M29.4_M39.4 TS1M29.4 TS1M3
Microsoft Windows Server 2012 Std9.4_M29.4_M39.4 TS1M29.4 TS1M3
Windows 7 Enterprise x649.4_M29.4_M39.4 TS1M29.4 TS1M3
Windows 7 Professional x649.4_M29.4_M39.4 TS1M29.4 TS1M3
64-bit Enabled AIX9.4_M29.4_M39.4 TS1M29.4 TS1M3
64-bit Enabled Solaris9.4_M29.4_M39.4 TS1M29.4 TS1M3
HP-UX IPF9.4_M29.4_M39.4 TS1M29.4 TS1M3
Linux for x649.4_M29.4_M39.4 TS1M29.4 TS1M3
Solaris for x649.4_M29.4_M39.4 TS1M29.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.