Problem Note 47048: "ERROR: File DI_MON.TMP_STG_PROMOTION_X.DATA does not exist" generated after running the Load_STG2DM_Promotion_fact job
 |  |  |  |
When running the Load_STG2DM_Promotion_fact job in the SAS® Revenue Optimization Suite, the following error might be generated in the di_etl_update_promotion_fact child logs:
ERROR: File DI_MON.TMP_STG_PROMOTION_X.DATA does not exist.
This error occurs because the parallel execution sessions are incorrectly attempting to simultaneously update tables.
To work around this issue, run the Load_STG2DM_Promotion_fact job in sequential mode by setting the following parameters in your execution session:
- Define a global macro variable named "IN_STORED_PROCESS" and set it equal to 1.
- Set the job parameter "etlp_delete_work_table" to "N" in the DI_MON.JOB_PARAM table.
A fix for this issue is planned for a future software release.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Markdown Optimization | Linux for x64 | 5.2 | 5.2_M1 | 9.3 TS1M0 | 9.3 TS1M0 |
| Microsoft® Windows® for x64 | 5.2 | 5.2_M1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| SAS System | SAS Regular Price Optimization | Microsoft® Windows® for x64 | 5.2 | 5.2_M1 | 9.3 TS1M0 | 9.3 TS1M0 |
| Linux for x64 | 5.2 | 5.2_M1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| SAS System | SAS Promotion Optimization | Microsoft® Windows® for x64 | 5.2 | 5.2_M1 | 9.3 TS1M0 | 9.3 TS1M0 |
| Linux for x64 | 5.2 | 5.2_M1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| SAS System | SAS Retail Forecasting | Linux for x64 | 5.2 | 5.2_M1 | 9.3 TS1M0 | 9.3 TS1M0 |
| Microsoft® Windows® for x64 | 5.2 | 5.2_M1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2012-08-30 11:10:19 |
| Date Created: | 2012-07-20 14:31:23 |