Problem Note 51212: PROMOTION_FACT and PROMOTION_FACT_FUTURE partition tables are missing indexes and might be empty
Following installation of hot fix D81024 for SAS® Merchandise Intelligence 4.2 M1, one or more of the following issues might exist after an incremental promotion fact data load using the Load_STG2DM_Promotion_fact job:
- Lost data in the PROMOTION_FACT_FUTURE folder partition tables.
- Significantly less data in the PROMOTION_FACT folder partition tables.
- Missing indexes on the PROMOTION_FACT and PROMOTION_FACT_FUTURE partition tables.
- Estimation fails with the following error:
ERROR: No Index found PLIB.PARTITION_214035 using columns PROD_HIER_SK GEO_HIER_SK
To work around this issue, perform the following steps:
- Restore the PROMOTION_FACT partition tables to a known good state (prior to the first incremental load using the Load_STG2DM_Promotion_fact job following D81024 installation). You do not need to restore the PROMOTION_FACT_FUTURE partition tables because they can be built from the PROMOTION_FACT partition tables.
- Modify the job parameter etlp_price_hist_weeks_keep from 0 to 52 or greater in the JOB_PARAM table. This value should be based on the period for which you review Promotion KPIs.
- Run the Load_STG2DM_Promotion_fact job with the source data from the incremental that caused the issue. After running this job, you will still see incorrect indexes and lost data in the PROMOTION_FACT_FUTURE partition tables, but you should see significantly more data in the PROMOTION_FACT partition tables.
- Download rebuild_promo_fact_futr.sas and post_process_promo_fact_f1mi42.sas from the Downloads tab.
- Modify the following line in the rebuild_promo_fact_futr.sas file to reflect the correct saved file location:
%include "<add the correct path to file here>/post_process_promo_fact_f1mi42.sas";
- Run the post-process code, rebuild_promo_fact_futr.sas, which calls the post_process_promo_fact_f1mi42.sas code. After running this code, the PROMOTION_FACT_FUTURE partition tables should contain data and the indexes should be correct on both sets of partition tables. For cross-reference, the indexes are sourced from the empty PROMOTION_FACT and PROMOTION_FACT_FUTURE tables in your DI_DM library.
- Include the post-process code in your job stream until a fix for this issue is provided.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS Retail Forecasting | Microsoft Windows Server 2003 Datacenter Edition | 4.2_M1 | | 9.2 TS2M3 | |
Microsoft Windows Server 2003 Enterprise Edition | 4.2_M1 | | 9.2 TS2M3 | |
Microsoft Windows Server 2003 Standard Edition | 4.2_M1 | | 9.2 TS2M3 | |
Microsoft Windows Server 2003 for x64 | 4.2_M1 | | 9.2 TS2M3 | |
Microsoft Windows Server 2008 | 4.2_M1 | | 9.2 TS2M3 | |
Microsoft Windows Server 2008 for x64 | 4.2_M1 | | 9.2 TS2M3 | |
64-bit Enabled AIX | 4.2_M1 | | 9.2 TS2M3 | |
SAS System | SAS Regular Price Optimization | Microsoft Windows Server 2003 Datacenter Edition | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M1 |
Microsoft Windows Server 2003 Enterprise Edition | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M1 |
Microsoft Windows Server 2003 Standard Edition | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M1 |
Microsoft Windows Server 2003 for x64 | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M1 |
Microsoft Windows Server 2008 | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M1 |
Microsoft Windows Server 2008 for x64 | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M1 |
64-bit Enabled AIX | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M1 |
SAS System | SAS Promotion Optimization | Microsoft Windows Server 2003 Datacenter Edition | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M1 |
Microsoft Windows Server 2003 Enterprise Edition | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M1 |
Microsoft Windows Server 2003 Standard Edition | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M1 |
Microsoft Windows Server 2003 for x64 | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M1 |
Microsoft Windows Server 2008 | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M1 |
Microsoft Windows Server 2008 for x64 | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M1 |
64-bit Enabled AIX | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M1 |
*
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: | 2013-10-30 11:42:56 |
Date Created: | 2013-09-30 12:27:32 |