Select Your Region
Americas
Europe
Middle East & Africa
Asia Pacific
SUPPORT / SAMPLES & SAS NOTES
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
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| 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 | ||||