SUPPORT / SAMPLES & SAS NOTES
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 | ||||