Problem Note 10855: Teradata error regarding the use of database name with volatile table
occurs when running a selection rule
If you create a selection rule in the SAS Campaign Management component
that contains an 'Exclude' operator followed by a 'Map' set, and you are
accessing data in a Teradata database, you may receive an error similar
to the following:
Error Number: 40002
Line Number: 0
Component: Campaign Management Component
Module: MDoCounts
Procedure: mCreateTempTable
Description: 37000:[NCR][Teradata RDBMS] Database name, if
specified, must be the login user name for a volatile table.
Note: this error only occurs if you have the UseViewForInterimList
configuration options set to 'No'. A possible workaround is to change
UseViewForInterimList to 'Yes' and allow the application to create a
view instead of a volatile table.
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 | 7.5.2 | | |
| Microsoft Windows XP Professional | 7.5 | 7.5.2 | | |
| Microsoft Windows 2000 Professional | 7.5 | 7.5.2 | | |
| Microsoft Windows 2000 Advanced Server | 7.5 | 7.5.2 | | |
| Microsoft Windows 2000 Server | 7.5 | 7.5.2 | | |
| Microsoft Windows 2000 Datacenter Server | 7.5 | 7.5.2 | | |
*
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 10:31:09 |
| Date Created: | 2003-09-17 08:47:04 |
