Problem Note 55901: %DI_UTIL_SUBSET_DATAMART might generate "ERROR: The following columns were not found in the contributing tables: TABLE_NAME."
 |  |  |  |  |
When using the SAS® Merchandise Intelligence %DI_UTIL_SUBSET_DATAMART macro to create a data mart subset, errors similar to the following appear in the log if the IGNORE_TABLE option is specified:
Table: ALLOWED_PRICE_CHG_DATE ERROR: The following columns were not found in the contributing tables: TABLE_NAME. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.00 seconds
A data mart subset is not generated.
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 Markdown Optimization | Microsoft® Windows® for x64 | 5.2 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| Linux for x64 | 5.2 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| SAS System | SAS Promotion Optimization | Microsoft® Windows® for x64 | 5.2 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| Linux for x64 | 5.2 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| SAS System | SAS Size Profiling | Linux for x64 | 3.2 | 9.3 TS1M2 | ||
| Microsoft® Windows® for x64 | 3.2 | 9.3 TS1M2 | ||||
| SAS System | SAS Pack Optimization | Linux for x64 | 3.2 | 9.3 TS1M2 | ||
| Microsoft® Windows® for x64 | 3.2 | 9.3 TS1M2 | ||||
| SAS System | SAS Retail Forecasting | Linux for x64 | 5.2 | 9.3 TS1M2 | ||
| Microsoft® Windows® for x64 | 5.2 | 9.3 TS1M2 | ||||
| SAS System | SAS Regular Price Optimization | Linux for x64 | 5.2 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| Microsoft® Windows® for x64 | 5.2 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||
A fix for this issue for SAS Revenue Optimization 5.2_M4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/P20.html#55901A fix for this issue for SAS Size Optimization 3.2_M4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/P21.html#55901| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2015-08-13 09:26:24 |
| Date Created: | 2015-05-29 15:14:39 |