Problem Note 43404: The error "BY variables are not properly sorted on data set WORK.PROD_GEPGRP_DATA_TBL" when you run the di_md_gp_status_wrap job
You might encounter the following error when running the di_md_gp_status_wrap job in SAS® Promotion Optimization or SAS® Regular Price Optimization:
ERROR: BY variables are not properly sorted on data set
WORK.PROD_GEOGRP_DATA_TBL.
The workaround for this issue is to set the spec_value of PAR_BY_WEEK_REFRESH in the MODEL_GEO_PROD_STATUS_SPEC table to 1 and set gp_status_refresh=1 in the call to di_md_gp_status_wrap. The call to di_md_gp_status_wrap would look similar to the following:
%di_job_ro(include_task=%quote(gp_status_comp), gp_status_refresh=1);
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS Promotion Optimization | Microsoft Windows Server 2003 Datacenter Edition | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 |
Microsoft Windows Server 2003 Enterprise Edition | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 |
Microsoft Windows Server 2003 Standard Edition | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 |
Microsoft Windows Server 2003 for x64 | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 |
Microsoft Windows Server 2008 | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 |
64-bit Enabled AIX | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 |
SAS System | SAS Regular Price Optimization | Microsoft Windows Server 2003 Datacenter Edition | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 |
Microsoft Windows Server 2003 Enterprise Edition | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 |
Microsoft Windows Server 2003 Standard Edition | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 |
Microsoft Windows Server 2003 for x64 | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 |
Microsoft Windows Server 2008 | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 |
Microsoft Windows Server 2008 for x64 | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 |
64-bit Enabled AIX | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 |
*
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: | 2011-06-15 11:38:02 |
Date Created: | 2011-06-01 15:19:22 |