If an export definition contains duplicated fields, then an error
message is written reporting zero records exported, and in addition the
following errors appear in the remoteservices log:

   com.sas.iquery.strategies.sas.oma.relational.SQLGeneration -
   Multiple data items used in a business query have the same
   resultset ID.  All data items used as result items within a
   business query must have unique resultset IDs.

The following error will also be seen:

   [ERROR] com.sas.analytics.crm.flow.ejb.FlowBean - Async
   execution failure

The errors are also possible if selection criteria including a map
node are used to extract data from separate tables that contain
duplicate data item names from the source tables.  In this case there
might not be any duplicated names in the export.

A new SAS Marketing Automation custom attribute on the information map
will permit successful use of duplicate names in the source tables by
adding an attribute called OutputColumnName.

The attribute specifies a column name that is to be used in the
internally generated sql in place of the physical column name.  This
attribute is available beginning with Hot Fix 2 for SAS Marketing
Automation.


A fix for this issue is available at:

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

Operating System and Release Information

A fix for this issue for SAS Marketing Automation 4.2 is available at: