Problem Note 39073: Sending a macro statement to a SAS Share server via an SQL Execute may cause an error
After a client sends a macro statement to a Share server via SQL Execute,
the server may abend (debug mode) with an attempt to delete a "dead" pool.
proc sql;
connect to remote(server=shr7);
execute(%nrstr(%%)let MYMACVAR=3;) by remote;
quit;
This is the error you would receive on the server's log:
ERROR: Attempt to delete dead pool!
Currently there is no work-around.
Operating System and Release Information
| SAS System | Base SAS | 64-bit Enabled AIX | 9.2 TS1M0 | 9.2 TS2M3 |
| 64-bit Enabled HP-UX | 9.2 TS1M0 | 9.2 TS2M3 |
| Windows Vista | 9.2 TS1M0 | 9.2 TS2M3 |
| Microsoft Windows XP Professional | 9.2 TS1M0 | 9.2 TS2M3 |
| z/OS | 9.2 TS1M0 | 9.2 TS2M3 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS1M0 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS1M0 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS1M0 | 9.2 TS2M3 |
| Microsoft Windows XP 64-bit Edition | 9.2 TS1M0 | 9.2 TS2M3 |
| Microsoft® Windows® for x64 | 9.2 TS1M0 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS1M0 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS1M0 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS1M0 | 9.2 TS2M3 |
| 64-bit Enabled Solaris | 9.2 TS1M0 | 9.2 TS2M3 |
| HP-UX IPF | 9.2 TS1M0 | 9.2 TS2M3 |
| Linux | 9.2 TS1M0 | 9.2 TS2M3 |
| Linux for x64 | 9.2 TS1M0 | 9.2 TS2M3 |
| OpenVMS on HP Integrity | 9.2 TS1M0 | 9.2 TS2M3 |
| Solaris for x64 | 9.2 TS1M0 | 9.2 TS2M3 |
*
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.
Error is generated if an EXECUTE statement within SQL contains a macro statement.
| Type: | Problem Note |
| Priority: | low |
| Date Modified: | 2010-03-18 11:04:41 |
| Date Created: | 2010-03-18 10:51:35 |
