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:

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

%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:

A fix for this issue for SAS Scalable Performance Data Server 5.1 is available at: