Problem Note 11365: Incorrect count is returned when a selection rule or constraint includes
a numeric constant larger than 15 digits in the criteria
If you run a selection rule or use a constraint in the SAS Campaign
Management component that references a numeric constant with more than
15 digits, you may receive incorrect counts.
For example, the following selection rule:
Select Clients where Client ID = 1234567890123456
where Client ID is defined in the database as a 16 digit numeric field,
may not return the correct count. The wrong count occurs because the
SQL code generated by Campaign Management incorrectly converts the
constant from the specified value of 1234567890123456 to
1234567890123460, thereby retrieving the wrong (or no) records.
A Technical Support hot fix for this issue is available at:
http://ftp.sas.com/techsup/download/hotfix/cam75.html
Operating System and Release Information
| SAS System | SAS Campaign Management | Microsoft Windows 2000 Advanced Server | 7.5 | | | |
| Microsoft Windows XP Professional | 7.5 | | | |
| Microsoft Windows NT Workstation | 7.5 | | | |
| Microsoft Windows 2000 Datacenter Server | 7.5 | | | |
| Microsoft Windows 2000 Professional | 7.5 | | | |
| Microsoft Windows 2000 Server | 7.5 | | | |
*
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: | 2004-02-23 15:20:44 |
| Date Created: | 2003-11-25 15:41:20 |
