Problem Note 49825: The Load_STG2DM_Prf_sales_fact job generates "ERROR: A lock is not available for DI_DM.DATE_DM.DATA ..."
 |  |  |  |  |
The SAS® Size Profiling Load_STG2DM_Prf_sales_fact job might generate the following error in one or more of the Load_STG2DM_Prf_sales_fact..etl.exec.<n>.log files:
ERROR: A lock is not available for DI_DM.DATE_DM.DATA.
ERROR: Lock held by process <PID>.
ERROR: A lock is not available for DI_DM.DATE_DM.DATA.
ERROR: Lock held by process <PID>.
NOTE: Lookup table does not exist or cannot be opened: etls_temp_lookupview0
NOTE: Abort action indicated, condition= Lookup table missing: etls_temp_lookupview0
ERROR: Execution terminated by an ABORT statement at line 407 column 10.
PROD_ID= GEO_ID= START_DT=. END_DT=. SALES_UNITS=. SALES_AMT=. PROD_HIER_SK=. GEO_HIER_SK=.
DATE_SK=. FISCAL_START_DT=. FISCAL_END_DT=. CHANGE_FLG= missing0=0 missing1=0 missing2=0
etls_assign_target_value=0 nlobs=. dsid=0 exponent=. eof=0 rc0=. rc1=.
rc2=. error_total=0 exception_total=0 _ERROR_=1 _N_=1
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 1 observations read from the data set STG_LIB.STG_PRF_SALES_<n>.
WARNING: The data set WORK.LK_STG_PRF_SALES may be incomplete.
When this step was stopped there were 0 observations and 10 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
...
UNIT INFO: Completed Processing SYSCC = 20000
This issue occurs when two or more jobs try to access the DI_DM.DATE_DM table at the same time.
The workaround for this issue is to run the Load_STG2DM_Prf_sales_fact job in sequential mode.
To run in sequential mode define a macro variable IN_STORED_PROCESS in the same SAS Session where the Load_STG2DM_Prf_sales_fact job is running.
%let IN_STORED_PROCESS=1; %di_etl_load_partition(etlsaspath=<path_to_etl_jobs>,jobname=Load_STG2DM_Prf_sales_fact,l_prefix=Prf_sales_fact);
When you run Load_STG2DM_Prf_sales_fact job in sequential mode, the total elapsed time for all unit jobs to complete is greater than when it is run in parallel.
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 | Linux for x64 | 3.2_M1 | 3.2_M3 | 9.3 TS1M2 | 9.3 TS1M2 |
| 64-bit Enabled AIX | 3.2_M1 | 3.2_M3 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Microsoft® Windows® for x64 | 3.2_M1 | 3.2_M3 | 9.3 TS1M2 | 9.3 TS1M2 | ||
A fix for this issue for SAS Size Optimization 3.2_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/K37.html#49825| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2013-07-18 09:47:32 |
| Date Created: | 2013-05-01 15:03:05 |