SUPPORT / SAMPLES & SAS NOTES
Problem Note 56175: "ERROR: CONSTRAINT ADD did not complete, no WHERE clause received" might occur when you use WHERE constraints on SAS® SPD Server tables
 |  |  |  |  |
The error "ERROR: CONSTRAINT ADD did not complete, no WHERE clause received" might occur when you use WHERE constraints on SAS® Scalable Performance Data Server tables.
Here is an example:
27 PROC SPDO lib=foo;
NOTE: Enter "?;" to get info on all the SPDO commands.
Enter "SPDSMAC;" to get list and setting of all SPD macros.
28 SET ACLUSER;
NOTE: Acluser has been set to spdadm.
29 constraint add employees;
30 WHERE ("@SPDSUSR" = "BOSSMAN");
ERROR: CONSTRAINT ADD did not complete, no WHERE clause received.
31 constraint describe employees;
NOTE: Trying to DESCRIBE CONSTRAINT from dataset with no CONSTRAINT.
32 quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SPDO used (Total process time):
real time 0.01 seconds
cpu time 0.00 secondsClick 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* | |||
| SPDS | Scalable Performance Data Server | Microsoft® Windows® for x64 | 5.1 HF3 | 5.1 HF4 | ||
| Microsoft Windows 8.1 Enterprise x64 | 5.1 HF3 | 5.1 HF4 | ||||
| Microsoft Windows Server 2008 for x64 | 5.1 HF3 | 5.1 HF4 | ||||
| Windows 7 Enterprise x64 | 5.1 HF3 | 5.1 HF4 | ||||
| 64-bit Enabled AIX | 5.1 HF3 | 5.1 HF4 | ||||
| 64-bit Enabled Solaris | 5.1 HF3 | 5.1 HF4 | ||||
| HP-UX IPF | 5.1 HF3 | 5.1 HF4 | ||||
| Linux for x64 | 5.1 HF3 | 5.1 HF4 | ||||
| Solaris for x64 | 5.1 HF3 | 5.1 HF4 | ||||