Problem Note 58389: Creating an index on a SAS® Scalable Performance Data Server table from which all rows have been deleted results in a corrupted index
 |  |  |  |  |  |
Your indexes might become corrupted when you create indexes on a SAS SPD Server table from which all rows have been deleted.
Click the Full Code tab in this SAS Note to see an example of code that produces the following error in the SAS log:
ERROR: Index needs to be repaired.
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 | Linux for x64 | 5.1 HF6 | 5.1 HF7 | 9.4 TS1M3 | 9.4 TS1M3 |
| HP-UX IPF | 5.1 HF6 | 5.1 HF7 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| 64-bit Enabled Solaris | 5.1 HF6 | 5.1 HF7 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| 64-bit Enabled AIX | 5.1 HF6 | 5.1 HF7 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Windows 7 Professional x64 | 5.1 HF6 | 5.1 HF7 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Windows 7 Enterprise x64 | 5.1 HF6 | 5.1 HF7 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2012 Std | 5.1 HF6 | 5.1 HF7 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2012 R2 Std | 5.1 HF6 | 5.1 HF7 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 5.1 HF6 | 5.1 HF7 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2012 Datacenter | 5.1 HF6 | 5.1 HF7 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft® Windows® for x64 | 5.1 HF6 | 5.1 HF7 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Solaris for x64 | 5.1 HF6 | 5.1 HF7 | 9.4 TS1M3 | 9.4 TS1M3 | ||
Modify the macro variables to match your environment setting before submitting the code.
%let dom=spds51;
%let host=myhost.domain;
%let portno=5200;
libname foo sasspds "&dom" host="&host" serv="&portno" user='anonymous';
data foo.class;
set sashelp.class;
run;
proc sql;
delete from foo.class;
quit;
proc datasets lib=foo nolist;
modify class;
index create name;
quit;
proc append base=foo.class data=sashelp.class;
run;
A fix for this issue for SAS Scalable Performance Data Server 5.2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/U88.html#58389A 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#58389
"ERROR: Index needs to be repaired." might occur when you create an index on a SAS SPD server.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2016-07-07 12:14:30 |
| Date Created: | 2016-06-14 08:00:26 |