Problem Note 59625: The message "ERROR: CONSTRAINT ADD did not complete" occurs when you use the GROUP keyword in the WHERE constraint
If you use the GROUP keyword in the WHERE constraint, an error message similar to the following is written to the SAS log:
24 constraint add whconstraint; 25 where (GROUP = "@SPDSGRP"); ERROR: CONSTRAINT ADD did not complete. 26 quit;
To circumvent this issue, you would need to escape the GROUP keyword as shown in the following example:
constraint add whconstraint; where (\GROUP = "@SPDSGRP");
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SPDS | SAS Scalable Peformance Data Server | Microsoft® Windows® for x64 | 5.3 | 5.3 HF1 | 9.4 TS1M3 | 9.4 TS1M3 |
Microsoft Windows Server 2012 Datacenter | 5.3 | 5.3 HF1 | 9.4 TS1M3 | 9.4 TS1M3 |
Microsoft Windows Server 2012 R2 Datacenter | 5.3 | 5.3 HF1 | 9.4 TS1M3 | 9.4 TS1M3 |
Microsoft Windows Server 2012 R2 Std | 5.3 | 5.3 HF1 | 9.4 TS1M3 | 9.4 TS1M3 |
Microsoft Windows Server 2012 Std | 5.3 | 5.3 HF1 | 9.4 TS1M3 | 9.4 TS1M3 |
Windows 7 Enterprise x64 | 5.3 | 5.3 HF1 | 9.4 TS1M3 | 9.4 TS1M3 |
64-bit Enabled AIX | 5.3 | 5.3 HF1 | 9.4 TS1M3 | 9.4 TS1M3 |
64-bit Enabled Solaris | 5.3 | 5.3 HF1 | 9.4 TS1M3 | 9.4 TS1M3 |
HP-UX IPF | 5.3 | 5.3 HF1 | 9.4 TS1M3 | 9.4 TS1M3 |
Linux for x64 | 5.3 | 5.3 HF1 | 9.4 TS1M3 | 9.4 TS1M3 |
Solaris for x64 | 5.3 | 5.3 HF1 | 9.4 TS1M3 | 9.4 TS1M3 |
*
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: | 2017-01-20 09:49:51 |
Date Created: | 2017-01-04 10:31:17 |