Problem Note 54088: The baseline_sas_validate_schema.sas job generates the error "BY variables are not properly sorted on data set WORK.COMP_CONSTRAINTS"
The SAS® Merchandise Intelligence baseline_sas_validate_schema.sas job might generate the following error in the baseline_sas_validate_schema.sas log file. This job is run only during migration from a prior release of SAS® Revenue Optimization or SAS® Size Optimization to release 5.2.
ERROR: BY variables are not properly sorted on data set WORK.COMP_CONSTRAINTS.
memname=VENDOR column_name=VENDOR_SK constraint_name=PRIM_KEY constraint_type=PRIMARY FIRST.memname=1 LAST.memname=1 COLUMN_NAMES=VEHICLE_SUPPORT_MAP_SK _ERROR_=1
_N_=218
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 219 observations read from the data set WORK.COMP_CONSTRAINTS.
WHERE constraint_type='PRIMARY';
WARNING: The data set WORK.COMP_PK_COLUMNS may be incomplete. When this step was stopped there were 104 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
ERROR: BY variables are not properly sorted on data set WORK.COMP_CONSTRAINTS.
memname=VEHICLE_SUPPORT_MAP_PREV column_name=SUPPORT_NM constraint_name=_NM0002_ constraint_type=NOT NULL FIRST.memname=1 LAST.memname=0 _ERROR_=1 _N_=23
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 24 observations read from the data set WORK.COMP_CONSTRAINTS.
WHERE constraint_type='NOT NULL';
WARNING: The data set WORK.COMP_NOT_NULL_CONS may be incomplete. When this step was stopped there were 22 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
This error occurs when data in the DICTIONARY.CONSTRAINT_COLUMN_USAGE table or the DICTIONARY.TABLE_CONSTRAINTS table is not in the expected sort order.
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 | Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| SAS System | SAS Retail Forecasting | Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| SAS System | SAS Markdown Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M2 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M2 |
| SAS System | SAS Regular Price Optimization | Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| SAS System | SAS Pack Optimization | Microsoft® Windows® for x64 | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.4 TS1M2 |
| 64-bit Enabled AIX | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.4 TS1M2 |
| Linux for x64 | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.4 TS1M2 |
| SAS System | SAS Size Profiling | Microsoft® Windows® for x64 | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.4 TS1M2 |
| 64-bit Enabled AIX | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.4 TS1M2 |
| Linux for x64 | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.4 TS1M2 |
*
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: | 2014-09-10 14:05:39 |
| Date Created: | 2014-09-10 10:04:30 |