Problem Note 36242: BY variables are not properly sorted on data set WORK._ODF_GP_EXISTING_STORE
 |  |  |  |  |
When using SAS® Markdown Optimization with the like store functionality enabled (NON_COMP_STORE_FCST global setting equal to 1), you may receive the following error in one of the child logs for the dipcl_opt_eval_workflow/Auto task:
ERROR: BY variables are not properly sorted on data set WORK._ODF_GP_EXISTING_STORE. PROD_HIER_SK=186349 GEO_HIER_SK=155 MODEL_GROUP_ID=73 FIRST.MODEL_GROUP_ID=1 LAST.MODEL_GROUP_ID=0 _ERROR_=1 _N_=2 NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 3 observations read from the data set WORK._ODF_GP_EXISTING_STORE. WARNING: The data set WORK._ODF_GP_FILTER_G may be incomplete. When this step was stopped there were 1 observations and 3 variables. WARNING: Data set WORK._ODF_GP_FILTER_G was not replaced because this step was stopped.
The only recommended workaround for this issue is to disable the like store functionality by setting the NON_COMP_STORE_FCST global setting equal to 0.
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 Markdown Optimization | Microsoft Windows 2000 Advanced Server | 3.2 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Datacenter Server | 3.2 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows 2000 Server | 3.2 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows 2000 Professional | 3.2 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows NT Workstation | 3.2 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 3.2 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 3.2 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows Server 2003 Standard Edition | 3.2 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows XP Professional | 3.2 | 9.1 TS1M3 SP4 | ||||
| Windows Vista | 3.2 | 9.1 TS1M3 SP4 | ||||
| 64-bit Enabled AIX | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
A fix for this issue for SAS Merchandise Intelligence 3.2 is available at:
http://www.sas.com/techsup/download/hotfix/ro32.html#036242| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2020-02-25 10:14:13 |
| Date Created: | 2009-06-16 12:01:45 |