SUPPORT / SAMPLES & SAS NOTES
 

Support

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

DetailsHotfixAboutRate It

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

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Pack OptimizationMicrosoft® Windows® for x643.2_M43.49.3 TS1M29.4 TS1M4
64-bit Enabled AIX3.2_M43.49.3 TS1M29.4 TS1M4
Linux for x643.2_M43.49.3 TS1M29.4 TS1M4
SAS SystemSAS Size ProfilingMicrosoft® Windows® for x643.2_M43.49.3 TS1M29.4 TS1M4
64-bit Enabled AIX3.2_M43.49.3 TS1M29.4 TS1M4
Linux for x643.2_M43.49.3 TS1M29.4 TS1M4
SAS SystemSAS Markdown OptimizationMicrosoft® Windows® for x645.2_M45.49.3 TS1M29.4 TS1M4
Linux for x645.2_M45.49.3 TS1M29.4 TS1M4
SAS SystemSAS Promotion OptimizationMicrosoft® Windows® for x645.2_M45.49.3 TS1M29.4 TS1M4
Linux for x645.2_M45.49.3 TS1M29.4 TS1M4
SAS SystemSAS Regular Price OptimizationMicrosoft® Windows® for x645.2_M45.49.3 TS1M29.4 TS1M4
Linux for x645.2_M45.49.3 TS1M29.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.