Problem Note 61277: Date and time values are truncated in an export table in SAS® Marketing Automation
Date and time values might be truncated to 33 characters when you use Custom Details tags in a treatment for an export table in SAS Marketing Automation.
This problem might happen when multiple treatments are assigned in a campaign and you have conditions that are similar to the following:
- Under Environment Variables ► Campaign (on the Setup tab) in SAS® Customer Intelligence Studio, the parameter Separator for treatment values is set to Comma, as shown below.
- Under Holdouts in the properties for the Communication node, Enable Holdout is selected.
- Two or more treatments are assigned in a campaign.
- Each treatment uses two Date elements with a value of Date and time for Date type.
- Each Custom Details element in the treatment is defined with a unique Custom detail tag definition.
- The Custom detail tag values from the treatments are assigned as fields in an export definition.
- The export definition is added to a Communication node, as shown below:
- You click the Preview Export button. When you do this, the concatenated date and time values in the table are truncated to 33 characters, as shown here:
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS Marketing Automation | Microsoft® Windows® for x64 | 6.5 | | 9.4 TS1M3 | |
64-bit Enabled AIX | 6.5 | | 9.4 TS1M3 | |
64-bit Enabled Solaris | 6.5 | | 9.4 TS1M3 | |
HP-UX IPF | 6.5 | | 9.4 TS1M3 | |
Linux for x64 | 6.5 | | 9.4 TS1M3 | |
Solaris for x64 | 6.5 | | 9.4 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.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2018-07-16 09:36:45 |
Date Created: | 2017-10-20 15:28:08 |