Problem Note 43654: Duplicate PROD_IDs in the ATTR_PROD_DM table
 |  |  |  |  |
When using SAS® High-Performance Markdown Optimization, you might notice duplicate PROD_IDs introduced into the ATTR_PROD_DM table following an incremental data load. The duplicates correspond to negative PROD_HIER_SK records. You might also notice errors similar to the following in the TKMI server log when running the batch_est command:
10:26:54 c_attr_prod_hier_assoc_dm: Error: cannot find a product for sk -279337, therefore cannot add its child product sk -246386 to the hierarchy 10:26:54 c_attr_prod_hier_assoc_dm: Error: cannot find a product for sk -279337, therefore cannot add its child product sk -246385 to the hierarchy 10:26:54 c_attr_prod_hier_assoc_dm: Error: cannot find a product for sk -248493, therefore cannot add its child product sk -246384 to the hierarchy
In addition, optimization failures might occur due to missing forecasts and elasticities which stem from incomplete model group coverage of the duplicates introduced.
During the incremental data load, there is an accidental override of the PROD_ID generated by the system with the PROD_ID from the PRODUCT_DM table. This only happens when standard hierarchy levels are intertwined with attribute hierarchy levels in the analytical hierarchy. If attribute levels are placed consecutively between the top and bottom standard levels, then the issue will not occur. For example, if the analytical hierarchy levels can be divided into 3 sections: top section with standard levels only, middle-section with attribute levels only and lower-section with standard levels only, then duplicate PROD_IDs will NOT be introduced. However, if the analytical hierarchy is defined like standard levels -> attribute levels -> standard levels -> attribute levels -> standard levels, then duplicate PROD_IDs will occur.
There is no work-around for this issue. Contact Technical Support for assistance.
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 High-Performance Markdown Optimization | Linux for x64 | 4.3 | 4.3_M2 | 9.2 TS2M3 | 9.2 TS2M3 |