Problem Note 63891: Copying a large SAS® Scalable Performance Data Server 5.1 table with indexes using PROC COPY can corrupt the table
 |  |  |  |  |
Copying a large table with indexes from SAS Scalable Performance Data Server 5.1 using the COPY procedure can corrupt the table. There is no indication of the problem at the time that the copying occurs.
Attempts to access the table after you copy it can generate this error in the SAS log:
This problem is related to the number of data partition files (DPFs) that are created for the table. When there are approximately 200 DPF files, the error can be triggered. However, this number can vary.
A workaround is to increase the MINPARTSIZE parameter file option in the spdsserv.parm file to write larger but fewer DPFs to disk.
This issue affects only SAS Scalable Performance Data Server 5.1.
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 | SAS Scalable Peformance Data Server | Microsoft® Windows® for x64 | 5.1 | 5.2 | 9.4 TS1M0 | |
| Microsoft Windows 8 Pro x64 | 5.1 | 5.2 | 9.4 TS1M0 | |||
| Microsoft Windows 8 Enterprise x64 | 5.1 | 5.2 | 9.4 TS1M0 | |||
| Microsoft Windows 8.1 Enterprise 32-bit | 5.1 | 5.2 | 9.4 TS1M0 | |||
| Microsoft Windows 8.1 Enterprise x64 | 5.1 | 5.2 | 9.4 TS1M0 | |||
| Microsoft Windows 8.1 Pro 32-bit | 5.1 | 5.2 | 9.4 TS1M0 | |||
| Microsoft Windows 8.1 Pro x64 | 5.1 | 5.2 | 9.4 TS1M0 | |||
| Microsoft Windows 10 | 5.1 | 5.2 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2008 R2 | 5.1 | 5.2 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2008 for x64 | 5.1 | 5.2 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 Datacenter | 5.1 | 5.2 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 R2 Datacenter | 5.1 | 5.2 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 R2 Std | 5.1 | 5.2 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 Std | 5.1 | 5.2 | 9.4 TS1M0 | |||
| Windows 7 Enterprise x64 | 5.1 | 5.2 | 9.4 TS1M0 | |||
| Windows 7 Professional x64 | 5.1 | 5.2 | 9.4 TS1M0 | |||
| 64-bit Enabled AIX | 5.1 | 5.2 | 9.4 TS1M0 | |||
| 64-bit Enabled Solaris | 5.1 | 5.2 | 9.4 TS1M0 | |||
| HP-UX IPF | 5.1 | 5.2 | 9.4 TS1M0 | |||
| Linux for x64 | 5.1 | 5.2 | 9.4 TS1M0 | |||
| Solaris for x64 | 5.1 | 5.2 | 9.4 TS1M0 | |||
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#63891| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-03-25 09:06:18 |
| Date Created: | 2019-03-22 02:07:49 |