SUPPORT / SAMPLES & SAS NOTES
Problem Note 41813: ETL job to load cost fact data fails
 |  |  |  |  |
While loading cost fact data into SAS® High-Performance Markdown Optimization, the ETL job LOAD_STG2DM_COST_FACT might fail. You might see an error similar to the one below in one of the Load_STG2DM_Cost_fact.log.Load_STG2DM_Cost_fact..etl_exec_job.<#>.log unit log files.
ERROR: A lock is not available for DI_MON.STG_PROD_COST_X.DATA. ERROR: Lock held by process <process_number>.
This error occurs because LOAD_STG2DM_COST_FACT runs multiple session in parallel. One session might attempt to get a lock on the table DI_MON.STG_PROD_COST_X while another session is reading the table at the same time. This results in a locking error.
The work around is to rerun the job.
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 High-Performance Markdown Optimization | Linux for x64 | 4.3 | 4.3_M1 | 9.2 TS2M3 | 9.2 TS2M3 |