For SAS Marketing Optimization 6.1 or later, metadata is no longer refreshed automatically when you refresh SAS Marketing Optimization input data and the underlying data has changed.

When this problem occurs, the following error is generated in the application:

In addition, the following error appears in the SASMarketingOptimizationdate_x.log file that is located in the SAS-configuration-directory\Lev1\Applications\SASCustomerIntelligence\MarketingOptimization\Logs directory:

This problem happens because, starting with SAS Marketing Optimization 6.1, a new macro was introduced to verify that metadata matches the physical table. Adding columns is okay, but not the removal or renaming of a column.

As a workaround, you can use either SAS^® Management Console or SAS^® Enterprise Guide^® to refresh the metadata before you refresh the input data for SAS Marketing Optimization.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Note: After you apply the hot fix, the behavior for refreshing SAS Marketing Optimization input data is as follows:

• Adding a new column: Uploading the input data automatically registers the table in metadata so that the new column is included.
• Removing a column that has NOT been selected as a customer attribute: Uploading the input data automatically registers the table in metadata so that the deleted column is no longer included.
• Removing a column that has been selected as a customer attribute: Uploading the input data automatically registers the table in metadata. However, errors still appear in the user interface because this data is treated like it is a new column.
• Renaming a column that has NOT been selected as a customer attribute: Uploading the input data automatically registers the table in metadata so that the renamed column is included. The old name is no longer available.
• Renaming a column that has been selected as a customer attribute: Uploading the input data automatically registers the table in metadata. However, errors still appear in the user interface because this data is treated like it is a new column.

Operating System and Release Information

A fix for this issue for SAS Marketing Optimization 6.5 is available at:

A fix for this issue for SAS Marketing Optimization 6.4 is available at: