Problem Note 53732: A PROC SQL query might return incorrect results in dynamic locking domain in SAS® Scalable Performance Data Server
 |  |  |  |  |
If you use the SQL procedure to submit concurrent queries in dynamic locking domain, incorrect results might be returned.
The problem occurs when at least two separate client sessions are running. One session must be querying a SAS Scalable Performance Data Server table while another session is performing UPDATE or APPEND operations against the same table.
In addition, the table must have defined indexes, and those indexes must be used in the query.
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 | Scalable Performance Data Server | Microsoft® Windows® for x64 | 5.1 HF1 | 5.1 HF2 | ||
| Microsoft Windows Server 2003 for x64 | 5.1 HF1 | 5.1 HF2 | ||||
| Microsoft Windows Server 2008 for x64 | 5.1 HF1 | 5.1 HF2 | ||||
| Microsoft Windows Server 2012 Datacenter | 5.1 HF1 | 5.1 HF2 | ||||
| Microsoft Windows Server 2012 R2 Datacenter | 5.1 HF1 | 5.1 HF2 | ||||
| 64-bit Enabled AIX | 5.1 HF1 | 5.1 HF2 | ||||
| 64-bit Enabled Solaris | 5.1 HF1 | 5.1 HF2 | ||||
| HP-UX IPF | 5.1 HF1 | 5.1 HF2 | ||||
| Linux for x64 | 5.1 HF1 | 5.1 HF2 | ||||
| Solaris for x64 | 5.1 HF1 | 5.1 HF2 | ||||
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#53732
If you are running more than one client session where one session is querying a table while another is performing UPDATE or APPEND operations, you might see incorrect results.
| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2014-08-29 11:24:45 |
| Date Created: | 2014-07-24 07:45:34 |