SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 11648: 'Holding table does not exist for selection group xx/yy/zzzz' error occurs when running a selection rule

DetailsHotfixAboutRate It
In the SAS Campaign Management component, if you create a selection rule
and save it with a name that contains only digits, then create and save
a second selection rule that references the first (for example, in an
INCLUDE or EXCLUDE set), when you recall the second rule and try to
execute it you receive an error.  The error occurs because the
application attempts to format the name of the selection group into a
date in the definition of the second rule, and the formatted group name
doesn't match the name of the holding table that was created by the
first rule.

For example, if you name your first rule "02 187" you will receive the
following error when you run your second rule:

   Holding table does not exist for selection group 01/02/0187

To circumvent this problem, you should prepend an alpha character to the
name of any selection rule whose name only contains numbers.  If there
are a large number of rules, you may programmatically solve this problem
by prepending an alpha character (without a space) to the NAME field in
the ISMDEFINITION and ISMGROUP tables.


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

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Campaign ManagementMicrosoft Windows 2000 Server7.5
Microsoft Windows NT Workstation7.5
Microsoft Windows 2000 Advanced Server7.5
Microsoft Windows 2000 Datacenter Server7.5
Microsoft Windows 2000 Professional7.5
Microsoft Windows XP Professional7.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.