Problem Note 10587: 'Invalid column name' error when running a selection rule
You may receive the following error when running a selection rule in
the SAS Campaign Management component:
Error Number: 40002
Line Number: 0
Component: Campaign Management Component
Module: MDoCounts
Procedure: sServerMakeView
Description: S0022: [Oracle][ODBC][Ora]ORA-00904: invalid column name
This error occurs when your selection rule contains a 'With Any' set
operator immediately after an 'And Any' set operator, and the 'With
Any' operator is in the fourth line or below. In addition, the rule
must be based on a table other than the root table and the second set
be joined back to the root table via a foreign key. For example, this
rule produces the error:
Select Motors Where Agency Code Is Not Blank
And any Household Where Household Id Is Not Blank
And any Motor Associate Where Associate Id Is Not Blank
With any Client Where Client Id Is Not Blank
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.5 | | | |
| Microsoft Windows XP Professional | 7.5 | | | |
| Microsoft Windows 2000 Professional | 7.5 | | | |
| Microsoft Windows 2000 Advanced Server | 7.5 | | | |
| Microsoft Windows 2000 Server | 7.5 | | | |
| Microsoft Windows 2000 Datacenter 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: | 2003-11-13 10:43:26 |
| Date Created: | 2003-08-07 14:21:57 |
