Problem Note 62828: The Parallel Group-By facility produces an incorrect count for a composite index when the COUNT(distinct value) function is used
 |  |  |  |  |
When the Parallel Group-By facility is used with the COUNT(distinct value) function in SAS® Scalable Performance Data Server, you might see an incorrect count result for a composite index in your SAS log.
The error occurs because the metadata scan logic, when determining the distinct count for a value, counts the number of unique composite keys in an index instead of counting the distinct values that compose the keys.
To work around the problem, disable the Parallel Group-By facility index metadata scan.
To disable the scan, use one of the following SQL reset options:
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 HF7 | 5.1 HF9 | 9.4 TS1M3 | |
| 64-bit Enabled AIX | 5.1 HF7 | 5.1 HF9 | 9.4 TS1M3 | |||
| 64-bit Enabled Solaris | 5.1 HF7 | 5.1 HF9 | 9.4 TS1M3 | |||
| HP-UX IPF | 5.1 HF7 | 5.1 HF9 | 9.4 TS1M3 | |||
| Linux for x64 | 5.1 HF7 | 5.1 HF9 | 9.4 TS1M3 | |||
| Solaris for x64 | 5.1 HF7 | 5.1 HF9 | 9.4 TS1M3 | |||
A fix for this issue for SAS Scalable Performance Data Server 5.4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/C9A.html#62828A fix for this issue for SAS Scalable Performance Data Server 5.3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/A3J.html#62828A 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#62828A 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#62828| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2018-08-29 10:33:53 |
| Date Created: | 2018-08-28 04:50:07 |