Problem Note 10649: Too many records are output when running an export
If you run an export in the SAS Campaign Management component where a
subsidiary table in the interface definition contains a compound key,
more records may be output than expected.
This occurs because the generated SQL cannot always determine a minimum
or maximum value for the compound key field. Consequently, for
selection group members who have multiple matches in the subsidiary
table, the ordering algorithm is unable to limit the export rows to a
single value, so it writes all matching records. As a result, too many
records are output to the export file.
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 NT Workstation | 7.4 | | | |
Microsoft Windows XP Professional | 7.4 | | | |
Microsoft Windows 2000 Professional | 7.4 | | | |
Microsoft Windows 2000 Advanced Server | 7.4 | | | |
Microsoft Windows 2000 Server | 7.4 | | | |
Microsoft Windows 2000 Datacenter Server | 7.4 | | | |
*
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: | alert |
Date Modified: | 2003-11-13 10:38:43 |
Date Created: | 2003-08-12 15:14:55 |