Problem Note 46433: A "BY variables are not properly sorted.." error occurs when you run Load_STG2DM_Product_group_mbr or Load_STG2DM_Profile_attr jobs
When you run the Load_STG2DM_Product_group_mbr or Load_STG2DM_Profile_attr jobs while loading data for the SAS® Merchandise Intelligence solutions, the following error might be displayed:
ERROR: BY variables are not properly sorted on data set <data_set>
This error occurs because some of the temporary tables that are generated while data is loaded are not in the proper sort order before they are merged.
There is no workaround for this issue.
Operating System and Release Information
| SAS System | SAS Promotion Optimization | 64-bit Enabled AIX | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 for x64 | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 for x64 | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| SAS System | SAS Regular Price Optimization | Microsoft Windows Server 2003 for x64 | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| 64-bit Enabled AIX | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 for x64 | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| SAS System | SAS High-Performance Markdown Optimization | Linux for x64 | 4.3_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| SAS System | SAS Size Profiling | Microsoft Windows Server 2003 Datacenter Edition | 2.2_M1 | 3.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 2.2_M1 | 3.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 2.2_M1 | 3.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 for x64 | 2.2_M1 | 3.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 | 2.2_M1 | 3.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 for x64 | 2.2_M1 | 3.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| 64-bit Enabled AIX | 2.2_M1 | 3.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| SAS System | SAS Pack Optimization | Microsoft Windows Server 2003 Datacenter Edition | 2.2_M1 | 3.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 2.2_M1 | 3.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 2.2_M1 | 3.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 for x64 | 2.2_M1 | 3.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 | 2.2_M1 | 3.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 for x64 | 2.2_M1 | 3.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| 64-bit Enabled AIX | 2.2_M1 | 3.2 | 9.2 TS2M3 | 9.3 TS1M0 |
*
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: | medium |
| Date Modified: | 2012-05-02 10:56:21 |
| Date Created: | 2012-04-26 14:56:17 |
