Problem Note 51756: The SAS® Merchandise Intelligence Load_STG2DM_Product_hier_assoc_dm job runs for a long time
 |  |  |  |  |
The SAS Merchandise Intelligence Load_STG2DM_Product_hier_assoc_dm job might run for a long time. This is most likely to happen in environments that have been migrated from a prior release of the software.
This issue occurs because of an SQL query that performs poorly.
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 Pack Optimization | Linux for x64 | 3.2_M3 | 3.2_M4 | 9.3 TS1M2 | 9.3 TS1M2 |
| 64-bit Enabled AIX | 3.2_M3 | 3.2_M4 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Microsoft® Windows® for x64 | 3.2_M3 | 3.2_M4 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| SAS System | SAS Size Profiling | Linux for x64 | 3.2_M3 | 3.2_M4 | 9.3 TS1M2 | 9.3 TS1M2 |
| 64-bit Enabled AIX | 3.2_M3 | 3.2_M4 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Microsoft® Windows® for x64 | 3.2_M3 | 3.2_M4 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| SAS System | SAS Retail Forecasting | Linux for x64 | 5.2_M3 | 5.2_M4 | 9.3 TS1M2 | 9.3 TS1M2 |
| Microsoft® Windows® for x64 | 5.2_M3 | 5.2_M4 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| SAS System | SAS Regular Price Optimization | Linux for x64 | 5.2_M3 | 5.2_M4 | 9.3 TS1M2 | 9.3 TS1M2 |
| Microsoft® Windows® for x64 | 5.2_M3 | 5.2_M4 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| SAS System | SAS Promotion Optimization | Linux for x64 | 5.2_M3 | 5.2_M4 | 9.3 TS1M2 | 9.3 TS1M2 |
| Microsoft® Windows® for x64 | 5.2_M3 | 5.2_M4 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| SAS System | SAS Markdown Optimization | Windows Vista for x64 | 5.2_M3 | 5.2_M4 | 9.3 TS1M2 | 9.3 TS1M2 |
| Linux for x64 | 5.2_M3 | 5.2_M4 | 9.3 TS1M2 | 9.3 TS1M2 | ||
A fix for this issue for SAS Revenue Optimization 5.2_M3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/M38.html#51756A fix for this issue for SAS Size Optimization 3.2_M3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/M56.html#51756| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2013-12-12 09:27:07 |
| Date Created: | 2013-12-05 10:21:47 |