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 seconds
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
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 | | |
*
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: | 2015-07-16 07:12:57 |
Date Created: | 2015-07-14 08:30:07 |