Problem Note 57716: The error "The file is already locked by another user" can be issued when you update different SAS® SPD Engine data sets in the same library
 |  |  |  |  |
Programs that run in parallel and use different SAS® Scalable Performance Data (SPD) Engine data sets that reside in the same library can incorrectly generate the following error message:
When you create, query, remove, or update an index using PROC SQL, PROC DATASETS, or DICTIONARY tables, the metadata file and all of the locations in the index path are locked by the procedure while it gathers information about existing indexes. If a second program attempts to lock the data set for modification, query, or update, that program receives a message from the host system that the file is already locked. SAS® continues to attempt to lock the file and do its work.
This issue creates a situation in which the program runs successfully, but the error messages in the SAS log generate a nonzero return code.
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 | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | Solaris for x64 | 9.4 TS1M0 | 9.4 TS1M4 |
| Microsoft Windows 8 Enterprise x64 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft® Windows® for x64 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| z/OS 64-bit | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Linux for x64 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| HP-UX IPF | 9.4 TS1M0 | 9.4 TS1M4 | ||
| 64-bit Enabled Solaris | 9.4 TS1M0 | 9.4 TS1M4 | ||
| 64-bit Enabled AIX | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Windows 7 Professional x64 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Windows 7 Enterprise x64 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 Std | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 R2 Std | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 Datacenter | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 for x64 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 R2 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows 10 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Pro x64 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Pro x64 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| z/OS | 9.4 TS1M0 | 9.4 TS1M4 | ||
A fix for this issue for SAS Threaded Kernel Components for Scalable Performance Data 9.41_M3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/V36.html#57716| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-11-21 15:26:56 |
| Date Created: | 2016-02-23 15:19:09 |