SUPPORT / SAMPLES & SAS NOTES
 

Support

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

DetailsHotfixAboutRate It

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:

ERROR: The file is already locked by another user.

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 FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemBase SASSolaris for x649.4 TS1M09.4 TS1M4
Microsoft Windows 8 Enterprise x649.4 TS1M09.4 TS1M4
Microsoft® Windows® for x649.4 TS1M09.4 TS1M4
z/OS 64-bit9.4 TS1M09.4 TS1M4
Linux for x649.4 TS1M09.4 TS1M4
HP-UX IPF9.4 TS1M09.4 TS1M4
64-bit Enabled Solaris9.4 TS1M09.4 TS1M4
64-bit Enabled AIX9.4 TS1M09.4 TS1M4
Windows 7 Professional x649.4 TS1M09.4 TS1M4
Windows 7 Enterprise x649.4 TS1M09.4 TS1M4
Microsoft Windows Server 2012 Std9.4 TS1M09.4 TS1M4
Microsoft Windows Server 2012 R2 Std9.4 TS1M09.4 TS1M4
Microsoft Windows Server 2012 R2 Datacenter9.4 TS1M09.4 TS1M4
Microsoft Windows Server 2012 Datacenter9.4 TS1M09.4 TS1M4
Microsoft Windows Server 2008 for x649.4 TS1M09.4 TS1M4
Microsoft Windows Server 2008 R29.4 TS1M09.4 TS1M4
Microsoft Windows 109.4 TS1M09.4 TS1M4
Microsoft Windows 8.1 Pro x649.4 TS1M09.4 TS1M4
Microsoft Windows 8.1 Pro 32-bit9.4 TS1M09.4 TS1M4
Microsoft Windows 8.1 Enterprise x649.4 TS1M09.4 TS1M4
Microsoft Windows 8.1 Enterprise 32-bit9.4 TS1M09.4 TS1M4
Microsoft Windows 8 Pro x649.4 TS1M09.4 TS1M4
z/OS9.4 TS1M09.4 TS1M4
* 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.