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
| 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 |
*
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: | 2009-09-10 11:18:03 |
| Date Created: | 2009-08-28 09:32:03 |
