Problem Note 11040: Unexpected error occurs when running a selection rule containing an ALL
set followed by WITH MANY or WITH ONE
If you run a selection rule similar to the following in the SAS
Campaign Management component, you may receive errors:
Select TableA where Col1 >0
And All TableC where Col2 Not=1
With Many TableB where Col3 = F
The error occurs if TableC contains a compound key join field.
The error differs depending on what database platform is being used.
For example, if the database is Oracle, you will see this error:
Error Number: 40002
Line Number: 0
Component: Campaign Management Component
Module: MDoCounts
Procedure: sServerMakeView
Description: S1000: [Oracle][ODBC][Ora]ORA-00936: missing expression
If you are accessing SAS data, this error will appear:
Error Number: 40002
Line Number: 0
Component: Campaign Management Component
Module: MRDO
Procedure: CreateAsyncQueryResults
Description: S1000: [SAS][SAS ODBC Driver][SAS Server]ERROR:
Unresolved
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: | medium |
| Date Modified: | 2003-11-13 11:16:30 |
| Date Created: | 2003-10-13 14:44:51 |
