SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 14085: SAS Marketing Automation export fails when referencing a concatenated data item

DetailsHotfixAboutRate It
In Campaign Studio, when running a diagram or communication, an error
message similar to the following may appear:

   ERROR: Column DII_228 could not be found in the table/view
          identified with the correlation name M.

This can occur under the following circumstances:

   1.) By creating an export definition in SAS Management Console that
       includes a data item which has previously been defined as an
       expression comprising two or more data items concatenated
       together; for  example:

          root.FieldA || root.FieldB || root.FieldC

   2.) In Campaign Studio, creating a diagram or campaign that
       references the export definition as described in the previous
       step.

   3.) When the diagram is run or the campaign is executed, the process
       fails with the error above.

A fix for this issue is available at:

http://www.sas.com/techsup/download/hotfix/ma42.html#014085


Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS Campaign ManagementMicrosoft Windows 2000 Advanced Server9.1 TS1M3
Microsoft Windows 2000 Datacenter Server9.1 TS1M3
Microsoft Windows 2000 Server9.1 TS1M3
Microsoft Windows XP Professional9.1 TS1M3
* 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.