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
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 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | alert |
Date Modified: | 2015-08-13 09:26:24 |
Date Created: | 2015-05-29 15:14:39 |