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 |