Problem Note 59842: SAS® Merchandise Intelligence ETL and purge jobs might generate "ERROR: A lock is not available for " before a success lock is obtained
SAS Merchandise Intelligence ETL and purge jobs might generate the following errors during attempts and reattempts to lock a file:
ERROR: A lock is not available for <filename>.
ERROR: Lock held by process <pid>.
The errors above might appear multiple times in the log file when the job executes multiple attempts to lock the filename. If the file is locked successfully, the errors above are followed by the message below later in the log:
"NOTE: <filename> is now locked for exclusive access by you".
The workaround for this issue is to check the logs to confirm that locks are obtained and that the job completes with a SYSCC value of 4 or less. In the case of successful file locking, the error should be treated as a warning.
Operating System and Release Information
SAS System | SAS Pack Optimization | Microsoft® Windows® for x64 | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.4 TS1M4 |
64-bit Enabled AIX | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.4 TS1M4 |
Linux for x64 | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.4 TS1M4 |
SAS System | SAS Size Profiling | Microsoft® Windows® for x64 | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.4 TS1M4 |
64-bit Enabled AIX | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.4 TS1M4 |
Linux for x64 | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.4 TS1M4 |
SAS System | SAS Markdown Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M4 |
Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M4 |
SAS System | SAS Promotion Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M4 |
Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M4 |
SAS System | SAS Regular Price Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M4 |
Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.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.
Type: | Problem Note |
Priority: | alert |
Date Modified: | 2017-04-26 09:39:48 |
Date Created: | 2017-01-31 12:10:02 |