Problem Note 60485: Performing concurrent updates of a table in a stored process server causes SAS® Scalable Performance Data Server to stop responding
 |  |  |  |  |
When you execute a stored process job that performs concurrent updates on a SAS Scalable Performance Data Server table, the process might stop responding. The process stops if the table is located in a domain that has dynamic locking enabled.
This issue occurs when a second task requests an update lock on a table and the lock is released before the first task is completed, causing a deadlock.
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 Client | Microsoft® Windows® for x64 | 5.1 | 5.1 HF3 | 9.4 TS1M0 | |
| Microsoft Windows 8.1 Enterprise x64 | 5.1 | 5.1 HF3 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2008 for x64 | 5.1 | 5.1 HF3 | 9.4 TS1M0 | |||
| Windows 7 Enterprise x64 | 5.1 | 5.1 HF3 | 9.4 TS1M0 | |||
| Windows 7 Professional x64 | 5.1 | 5.1 HF3 | 9.4 TS1M0 | |||
| 64-bit Enabled AIX | 5.1 | 5.1 HF3 | 9.4 TS1M0 | |||
| 64-bit Enabled Solaris | 5.1 | 5.1 HF3 | 9.4 TS1M0 | |||
| HP-UX IPF | 5.1 | 5.1 HF3 | 9.4 TS1M0 | |||
| Linux for x64 | 5.1 | 5.1 HF3 | 9.4 TS1M0 | |||
| Solaris for x64 | 5.1 | 5.1 HF3 | 9.4 TS1M0 | |||
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#60485| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2017-06-12 14:37:22 |
| Date Created: | 2017-05-17 11:50:44 |