Problem Note 53232: The DI_ETL_Geo_prod_purge_job runs long
 |  |  |  |  |
The SAS® Merchandise Intelligence DI_ETL_Geo_prod_purge_job program might run slowly. This issue occurs when the DI_DM.PRODUCT_HIER_ASSOC_DM table is very large.
There is no workaround for this issue.
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 Retail Forecasting | Linux for x64 | 5.2_M3 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| Microsoft® Windows® for x64 | 5.2_M3 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| SAS System | SAS Markdown Optimization | Microsoft® Windows® for x64 | 5.2_M3 | 5.4 | 9.3 TS1M2 | 9.4 TS1M2 |
| Linux for x64 | 5.2_M3 | 5.4 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| SAS System | SAS Promotion Optimization | Linux for x64 | 5.2_M3 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| Microsoft® Windows® for x64 | 5.2_M3 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| SAS System | SAS Regular Price Optimization | Linux for x64 | 5.2_M3 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| Microsoft® Windows® for x64 | 5.2_M3 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| SAS System | SAS Size Profiling | Linux for x64 | 3.2_M3 | 3.4 | 9.3 TS1M2 | 9.4 TS1M2 |
| 64-bit Enabled AIX | 3.2_M3 | 3.4 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft® Windows® for x64 | 3.2_M3 | 3.4 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| SAS System | SAS Pack Optimization | Linux for x64 | 3.2_M3 | 3.4 | 9.3 TS1M2 | 9.4 TS1M2 |
| 64-bit Enabled AIX | 3.2_M3 | 3.4 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft® Windows® for x64 | 3.2_M3 | 3.4 | 9.3 TS1M2 | 9.4 TS1M2 | ||
A fix for this issue for SAS Size Optimization 3.2_M3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/M56.html#53232A fix for this issue for SAS Revenue Optimization 5.2_M4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/P20.html#53232A fix for this issue for SAS Size Optimization 3.2_M4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/P21.html#53232| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2014-07-15 15:15:36 |
| Date Created: | 2014-06-17 10:38:54 |