Problem Note 48288: Estimation fails when forecast disaggregation is enabled and FCST_DISAGG_PROD_LVL_OFFSET is greater than 0
 |  |  |  |  |
When forecast disaggregation is enabled and FCST_DISAGG_PROD_LVL_OFFSET > 0, estimation might fail in the SAS® Revenue Optimization Suite with an error similar to the following:
ERROR: Execution terminated by an ABORT statement at line 136 column 91.
GEO_HIER_SK=-46 PROD_HIER_SK=-1662 DATE_SK=20377 MISC_ADJ_INDEX=5.0000
PERIOD_IN_LIFECYCLE=1 SALES_UNITS_deREG=. parent_geo_hier_sk=-25
parent_prod_hier_sk=. cyclical_seasonal_index=. holiday_index=. seasonal_index=.
hs_outlier=. hash_prod_hier_sk=-1962
hash_geo_hier_sk=-25 rc=160038 outlier_flag=. target=. _ERROR_=1 _N_=1
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 1 observations read from the data set WORK._DEREG_DATA_REG.
WARNING: The data set WORK._NORMALIZED_DATA_REG may be incomplete.
When this step was stopped there were 0 observations and 10 variables.
The workaround is to not enable forecast disaggregation.
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 Promotion Optimization | Microsoft Windows Server 2003 Enterprise Edition | 4.2_M1 | 5.2_M1 | 9.2 TS2M3 | 9.3 TS1M2 |
| 64-bit Enabled AIX | 4.2_M1 | 5.2_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2008 for x64 | 4.2_M1 | 5.2_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2008 | 4.2_M1 | 5.2_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 for x64 | 4.2_M1 | 5.2_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2_M1 | 5.2_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.2_M1 | 5.2_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| SAS System | SAS Regular Price Optimization | Microsoft Windows Server 2003 Enterprise Edition | 4.2_M1 | 5.2_M1 | 9.2 TS2M3 | 9.3 TS1M2 |
| 64-bit Enabled AIX | 4.2_M1 | 5.2_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2008 | 4.2_M1 | 5.2_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 for x64 | 4.2_M1 | 5.2_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2008 for x64 | 4.2_M1 | 5.2_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.2_M1 | 5.2_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2_M1 | 5.2_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
A fix for this issue for SAS Merchandise Intelligence 4.2_M2 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/D81.html#48288| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2012-10-29 10:00:32 |
| Date Created: | 2012-10-29 09:40:23 |