Problem Note 53718: When you select multiple values from a dynamic list for a user-defined field, the values are not trimmed before they are published to the _EXT tables
 |  |  |  |  |
Spaces are inserted between values in a column for a user-defined field when you publish a campaign to _EXT tables. This problem occurs when you select multiple values from an external dynamic list for a user-defined field in SAS® Customer Intelligence Studio, as shown in the following display:
When you published the campaign, the values in the column for the user-defined field contain spaces in the CI_CAMPAIGN_EXT table as shown in the following example:
The selected values show a length of $13 because of the length that is defined for the column. The expected behavior is that the added spaces are removed when you publish the campaign. Otherwise, the _EXT table grows rapidly due to the unwanted spaces.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Customer Intelligence Core Mid-Tier | Microsoft® Windows® for x64 | 6.1_M1 | 6.3 | 9.4 TS1M0 | |
| 64-bit Enabled AIX | 6.1_M1 | 6.3 | 9.4 TS1M0 | |||
| 64-bit Enabled Solaris | 6.1_M1 | 6.3 | 9.4 TS1M0 | |||
| HP-UX IPF | 6.1_M1 | 6.3 | 9.4 TS1M0 | |||
| Linux for x64 | 6.1_M1 | 6.3 | 9.4 TS1M0 | |||
| Solaris for x64 | 6.1_M1 | 6.3 | 9.4 TS1M0 | |||
A fix for this issue for SAS Marketing Automation 6.1_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/K78.html#53718| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2014-08-21 13:55:32 |
| Date Created: | 2014-07-23 04:48:30 |