Problem Note 53734: When you use PROC SQL to insert or append rows to a table, SAS® Scalable Performance Data Server might fail
 |  |  |  |  |
If you use the SQL procedure to insert or append rows to a table, SAS® Scalable Performance Data Server might fail.
The problem occurs only when these factors are present:
- The IOBLOCKSIZE= option for the table has been set to a value greater than 32K.
- The table is compressed.
- The table is in a dynamic locking domain.
Errors similar to the following are reported in the SAS log file:
ERROR: Error on server LIBNAME socket.
ERROR: LIBREF ?{??.
NOTE: Deleting the successful inserts before error noted above to restore table
to a consistent state.
ERROR: ERROR: Server has disconnected..
ERROR: 10053 - WSAECONNABORTED.
60 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 Server | Microsoft® Windows® for x64 | 5.1 HF1 | 5.1 HF2 | ||
| Microsoft Windows Server 2003 for x64 | 5.1 HF1 | 5.1 HF2 | ||||
| Microsoft Windows Server 2008 for x64 | 5.1 HF1 | 5.1 HF2 | ||||
| Microsoft Windows Server 2012 Datacenter | 5.1 HF1 | 5.1 HF2 | ||||
| Microsoft Windows Server 2012 R2 Datacenter | 5.1 HF1 | 5.1 HF2 | ||||
| 64-bit Enabled AIX | 5.1 HF1 | 5.1 HF2 | ||||
| 64-bit Enabled Solaris | 5.1 HF1 | 5.1 HF2 | ||||
| HP-UX IPF | 5.1 HF1 | 5.1 HF2 | ||||
| Linux for x64 | 5.1 HF1 | 5.1 HF2 | ||||
| Solaris for x64 | 5.1 HF1 | 5.1 HF2 | ||||
A 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#53734
If you use PROC SQL to insert or append rows to a table with an IOBLOCKSIZE= option setting of >32K, SAS® Scalable Performance Data Server might fail and errors might be reported in the SAS log file.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2015-02-02 13:53:34 |
| Date Created: | 2014-07-24 09:25:01 |