SUPPORT / SAMPLES & SAS NOTES
Problem Note 54332: Attr_hier_job generates "ERROR: There are xxx differences between the lowest level nodes of PRODUCT_HIER_ASSOC_DM and ATTR_PROD_HIER_ASSOC_DM"
 |  |  |  |  |
When you run the %TKMI_JOB_RO attr_hier_job task in the SAS® Merchandise Intelligence Revenue Optimization Suite, error messages similar to the following might appear in the task log:
ERROR: There are xxx differences between the lowest level nodes of PRODUCT_HIER_ASSOC_DM and ATTR_PROD_HIER_ASSOC_DM.
ERROR: There are yyy differences between the lowest level nodes of GEOGRAPHY_HIER_ASSOC_DM and ATTR_GEO_HIER_ASSOC_DM.
The attr_hier_job task checks to make sure the lowest level node counts are the same in the standard hierarchy and in the analytical hierarchy. In an environment that also contains an alternate hierarchy, the counts do not match and these errors are generated. When an alternate hierarchy is present, these errors most likely do not indicate a data issue and can be ignored.
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 Markdown Optimization | Linux for x64 | 5.2 | 5.4 | 9.3 TS1M2 | 9.4 TS1M0 |
| SAS System | SAS Regular Price Optimization | Linux for x64 | 5.2 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| SAS System | SAS Promotion Optimization | Linux for x64 | 5.2 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| SAS System | SAS Retail Forecasting | Linux for x64 | 5.2 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |