Problem Note 53980: The SZPF_GP_STATUS_DERIVATION_UNIT task might generate "ERROR: A lock is not available for DI_DM.PRF_GEO_PROD_STATUS_META.DATA"
 |  |  |  |  |
In SAS® Size Profiling, the SZPF_GP_STATUS_DERIVATION_UNIT task might fail with errors similar to the following in the SZPF_GP_STATUS_DERIVATION_UNIT log:
NOTE: CHG_LIB.PRF_GEO_PROD_STATUS.DATA is no longer locked by you. ERROR: A lock is not available for DI_DM.PRF_GEO_PROD_STATUS_META.DATA. ERROR: A lock is not available for DI_DM.PRF_GEO_PROD_STATUS_META.DATA. ERROR: Lock held by process XXXXX.
There is no workaround for this issue.
Contact SAS Technical Support if you encounter this problem to obtain a script to ensure that the DI_DM.PRF_GEO_PROD_STATUS_META table is in sync with data in PRF_GEO_PROD_STATUS.
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* | |||
| SAS System | SAS Size Profiling | Microsoft® Windows® for x64 | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.3 TS1M0 |
| 64-bit Enabled AIX | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.3 TS1M0 | ||
| Linux for x64 | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.3 TS1M0 | ||
A fix for this issue for SAS Size Optimization 3.2_M4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/P21.html#53980| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2014-09-03 09:11:24 |
| Date Created: | 2014-08-25 12:35:22 |