Problem Note 37021: An array subscript out of range error occurs when running the di_dm_promo_price_fact_extract macro
 |  |  |  |  |
When running SAS® Markdown Optimization, you might encounter an error similar to the following when running the di_dm_promo_price_fact_extract macro:
ERROR: Array subscript out of range at line 541 column 8. res_start_dt=16NOV2008 res_end_dt=22NOV2008 res_abs_price=. res_abs_Discount=. res_percent_discount=30.00 geo_hier_sk=299 prod_hier_sk=237907 START_DT=28NOV2008 PRICE_VALUE_TYPE=1 END_DT=29NOV2008 PRICE_VALUE=2.5000 lvl=14 FIRST.geo_hier_sk=0 LAST.geo_hier_sk=0 FIRST.prod_hier_sk=0 LAST.prod_hier_sk=0 max_idx=51 i=49 first_open_idx=1 new_start_dt=17864 _ERROR_=1 _N_=55
This error occurs when overlapping promotions exist. There is no workaround for this issue.
Select 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 | Windows Vista | 2.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows XP Professional | 2.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2008 | 2.2 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows Server 2003 Standard Edition | 2.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 2.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 2.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows NT Workstation | 2.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Professional | 2.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Server | 2.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Datacenter Server | 2.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Advanced Server | 2.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled AIX | 2.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
A fix for this issue for SAS Merchandise Intelligence 3.2 is available at:
http://www.sas.com/techsup/download/hotfix/ro32.html#037021| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2009-09-10 11:18:03 |
| Date Created: | 2009-08-28 09:32:03 |