Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

If you use the SAS Campaign Management component to run an export set
up in the following manner, it will fail:

  - the selection rule is based on the root table
  - the interface definition is based on the root table
  - the interface definition fields are selected from only non-root
    tables
  - all index values are set to 'n/a'
  - a 'Conditional on Constraint' is added

When you run this export, you will receive the following unexpected
error:

  Error Number: 40002
   Line Number: 0
     Component: Campaign Management Component
        Module: frmExportDialog
     Procedure: ProcessConditionalConstraints
   Description: S0022:[SAS][SAS ODBC Driver]Column not found


A Technical Support hot fix for this issue is available at:
http://ftp.sas.com/techsup/download/hotfix/cam75.html

A new config setting, ConditionalConsSingleUpdate, which is used to
determine if the Export Conditional Constraints temporary table
can be updated using self-referencing subqueries, is available.
Only set to YES if the RDBMS supports self-referencing subqueries in
an UPDATE statement.  This setting is only recommended for Teredata.

Operating System and Release Information

A fix for this issue for Campaign Management Component 7.5 is available at: