Problem Note 45362: Intermittent errors reported in client session running a DISPLAY LIBRARY _ALL_ statement to a SAS/SHARE® Server
 |  |  |  |  |
If you execute the statement DISPLAY LIBRARY _ALL_ in an OPERATE procedure (PROC), a problem might occur: It is possible that the report returned to the SASLOG might show blank or garbage values, with or without an error message.
The following is one example, but sometimes all library names appear normal except for the last entry, which is blank:
NUMBER
LIBREF STATUS OF USERS LIBRARY NAME
--------------------------------------------------------------
ACTIVE 1 SASLIB.SAS.V8.SASDATA
ACTIVE 4 øøøøøøøøøøøøøøøøøøøøøøøø
ACTIVE 4 øøøøøøøøøøøøøøøøøøøøøøøø
ACTIVE 4 øøøøøøøøøøøøøøøøøøøøøøøø
ACTIVE 4 øøøøøøøø END;
ACTIVE 4 øøøøøøøøøøøøøøøøøøøøøøøø
ACTIVE 4 Qºrc = where(W5102T11,'U
ACTIVE 4 .& .-~cEND;&.õ& .-QcEND
ACTIVE 4 .& .-McEND;&.ä-D& .-&.
ACTIVE 4 õ& .-~gELSE DO;&.
ACTIVE 4 'UNDO');&. .& .-fRETURN;
ACTIVE 4 &. .-&. .-Jºrc = where(W
ACTIVE 4 .-&. .-fGETROW:&. .-&. .
ACTIVE 5 ELOBS(W5102T11);&. .& .-
ACTIVE 4 TCHOBS(W5102T11,_currow_
ACTIVE 4 .þ_msg_=sysmsg();&. .& .
ACTIVE 5
ERROR: A bug in SAS has been encountered. Please call your SAS representative and report the
following message:
OPRXSPN: FMT ERROR IN SERVER REPLY AT POSITION 780.
The problem occurs only when the same user-defined libraries are allocated through the SAS/SHARE Server by multiple clients. If the initial client for the user-defined library ends its connection to the SAS/SHARE Server for the library while it is still ACTIVE to other clients, then this problem could occur.
Note that this problem does not affect the functionality of the server, only the contents of the output from the DISPLAY LIBRARY _ALL_ command.
To circumvent this issue, you can require that all libraries managed by the SAS/SHARE Server be administrator libraries. An administrator library is a library that is under the control of the SAS/SHARE Server through the ALLOCATE LIBRARY command of PROC OPERATE. To restrict users from creating user-defined libraries to the SAS/SHARE Server, the Server should be started with the NOALLOC option. After you set this option on your server, if a client attempts to allocate a library dynamically, they see this message:
You cannot assign library 'NONSHARE.ADMIN.LIBRARY' because the NOALLOC option is in effect for server serverid. ERROR: Error in the LIBNAME statement.
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 | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/SHARE | z/OS | 9.4 TS1M0 | |
| OpenVMS VAX | 9.4 TS1M0 | |||
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.4 TS1M0 | |||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.4 TS1M0 | |||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.4 TS1M0 | |||
| Microsoft Windows XP 64-bit Edition | 9.4 TS1M0 | |||
| Microsoft® Windows® for x64 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2003 Datacenter Edition | 9.4 TS1M0 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 9.4 TS1M0 | |||
| Microsoft Windows Server 2003 Standard Edition | 9.4 TS1M0 | |||
| Microsoft Windows Server 2003 for x64 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2008 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2008 for x64 | 9.4 TS1M0 | |||
| Microsoft Windows XP Professional | 9.4 TS1M0 | |||
| Windows Vista | 9.4 TS1M0 | |||
| Windows Vista for x64 | 9.4 TS1M0 | |||
| 64-bit Enabled AIX | 9.4 TS1M0 | |||
| 64-bit Enabled HP-UX | 9.4 TS1M0 | |||
| 64-bit Enabled Solaris | 9.4 TS1M0 | |||
| ABI+ for Intel Architecture | 9.4 TS1M0 | |||
| AIX | 9.4 TS1M0 | |||
| HP-UX | 9.4 TS1M0 | |||
| HP-UX IPF | 9.4 TS1M0 | |||
| IRIX | 9.4 TS1M0 | |||
| Linux | 9.4 TS1M0 | |||
| Linux for x64 | 9.4 TS1M0 | |||
| Linux on Itanium | 9.4 TS1M0 | |||
| OpenVMS Alpha | 9.4 TS1M0 | |||
| OpenVMS on HP Integrity | 9.4 TS1M0 | |||
| Solaris | 9.4 TS1M0 | |||
| Solaris for x64 | 9.4 TS1M0 | |||
| Tru64 UNIX | 9.4 TS1M0 | |||