Problem Note 59200: The %TKMI_JOB_RO etl_end_service task generates "c_product_hier_assoc_dm: Error: (prod_hier_assoc_cd = 1) cannot find a product for sk ..."
 |  |  |  |  |
The SAS® Revenue Optimization %TKMI_JOB_RO etl_end_service task might generate the following error in the MerchIntelGridSvr.log file:
<YYYY-MM-DD HH:MM:SS,MMM> [pool-<n>-thread-<n>] DEBUG - STDOUT: <HH:MM:SS> c_product_hier_assoc_dm: Error:
(prod_hier_assoc_cd = 1) cannot find a product for sk <PROD_HIER_SK>
(level <STD_HIER_PROD_LVL>), therefore cannot add it to the hierarchy
(prod_hier_assoc_cd = 1) cannot find a product for sk <PROD_HIER_SK>
(level <STD_HIER_PROD_LVL>), therefore cannot add it to the hierarchy
This error occurs when the product identified as <PROD_HIER_SK> has a value for DI_DM.PRODUCT_DM.PROD_DISCONTINUED_DT that is less than DI_DM.PRODUCT_DM.PROD_INTRODUCTION_DT. This issue occurs when a STG_PRODUCT insert record (CHANGE_FLG = I) is sent for a PROD_ID that meets the following conditions:
- The PROD_ID already has an existing record in the data mart identified by <PROD_HIER_SK>.
- The data mart record does not have DI_DM.PRODUCT_DM.PROD_DISCONTINUED_DT populated.
- The STG_PRODUCT.PROD_INTRODUCTION_DT = DI_DM.PRODUCT_DM.PROD_INTRODUCTION_DT.
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_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M4 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M4 | ||
| SAS System | SAS Regular Price Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M4 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M4 | ||
| SAS System | SAS Promotion Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M4 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M4 | ||
A fix for this issue for SAS Size Optimization 3.4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/W19.html#59200A fix for this issue for SAS Revenue Optimization 5.2_M4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/P20.html#59200| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2018-02-26 12:55:42 |
| Date Created: | 2016-10-21 12:15:40 |