SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 11036: Error regarding duplicate column names occurs when running reports

DetailsHotfixAboutRate It
If you attempt to run a report in the SAS Campaign Management component
and the field names you choose are the same (even if they come from
different tables), you will receive an error similar to the following:

  Error Number: 40002
   Line Number: 0
     Component: Campaign Management Component
        Module: MCommon
     Procedure: BuildVolatile Table
   Description: S1000: [NCR][ODBC Teradata Driver][Teradata RDBMS]
                Duplication of column SUBCLASS in creating a Table,
                Macro or Trigger.


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 NT Workstation7.5
Microsoft Windows XP Professional7.5
Microsoft Windows 2000 Professional7.5
Microsoft Windows 2000 Advanced Server7.5
Microsoft Windows 2000 Server7.5
Microsoft Windows 2000 Datacenter Server7.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.