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
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
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 |
*
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: | high |
Date Modified: | 2018-02-26 12:55:42 |
Date Created: | 2016-10-21 12:15:40 |