Usage Note 17283: Lowering the MAXWHTHREADS= value can prevent unique indexing
With SPD Server 4.3 TSM1, if you have the MAXWHTHREADS= value set to
anything lower than the default value of 64, the index may not be
created as unique.
You will see the following error message in the SAS log:
ERROR: Duplicate keys appear in unique-type index.
The occurrence of the error depends on the size of the data set, the
number of observations, and the MAXWHTHREADS= value.
To obtain a fix for this problem, please download the lastest
SPD Server 4.3 TSM1 modules for your system from the SAS FTP download
site:
ftp.sas.com/techsup/download/spds
Operating System and Release Information
| SPDS | Scalable Performance Data Server | Microsoft Windows NT Workstation | 4.3 | | 9.1 TS1M3 SP2 | |
| Solaris | 4.3 | | 9.1 TS1M3 SP2 | |
| 64-bit Enabled Solaris | 4.3 | | 9.1 TS1M3 SP2 | |
| Linux on Itanium | 4.3 | | 9.1 TS1M3 SP2 | |
| HP-UX | 4.3 | | 9.1 TS1M3 SP2 | |
| HP-UX IPF | 4.3 | | 9.1 TS1M3 SP2 | |
| 64-bit Enabled HP-UX | 4.3 | | 9.1 TS1M3 SP2 | |
| Tru64 UNIX | 4.3 | | 9.1 TS1M3 SP2 | |
| 64-bit Enabled AIX | 4.3 | | 9.1 TS1M3 SP2 | |
| AIX | 4.3 | | 9.1 TS1M3 SP2 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Usage Note |
| Priority: | high |
| Topic: | System Administration ==> Servers ==> SPDS
|
| Date Modified: | 2006-06-22 17:26:53 |
| Date Created: | 2006-03-17 12:24:27 |
