Problem Note 49490: The %DI_JOB_RO job_est task might generate a "BY variables are not properly sorted on data set HMGP_LIB._MGP_EXCLUDE" error
When running the %DI_JOB_RO job_est task (calibration), the following error might be generated immediately after the DI_HIER_MODEL_GEO_PROD unit subtask processes.
ERROR: BY variables are not properly sorted on data set HMGP_LIB._MGP_EXCLUDE.
These products are involved: SAS® Regular Price Optimization; SAS® Promotion Optimization; and SAS® Retail Forecasting.
This issue occurs only when selected model groups are calibrated. The issue does not occur when all model groups are calibrated.
To work around this issue, the MODEL_GEO_PROD table must be sorted and re-indexed immediately following the job_est %DI_JOB_RO calibration task (job_est). Contact SAS Technical Support for sample code.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
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 |
SAS System | SAS Retail Forecasting | Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 5.2 | 9.2 TS2M3 | 9.3 TS1M1 |
Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 5.2 | 9.2 TS2M3 | 9.3 TS1M1 |
Microsoft Windows Server 2003 Standard Edition | 4.2 | 5.2 | 9.2 TS2M3 | 9.3 TS1M1 |
Microsoft Windows Server 2003 for x64 | 4.2 | 5.2 | 9.2 TS2M3 | 9.3 TS1M1 |
Microsoft Windows Server 2008 | 4.2 | 5.2 | 9.2 TS2M3 | 9.3 TS1M1 |
Microsoft Windows Server 2008 for x64 | 4.2 | 5.2 | 9.2 TS2M3 | 9.3 TS1M1 |
64-bit Enabled AIX | 4.2 | 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: | high |
Date Modified: | 2013-07-25 09:45:40 |
Date Created: | 2013-03-25 10:23:19 |