Problem Note 53662: Exporting custom detail tags in SAS® Customer Intelligence might result in huge files that can cause out-of-disk-space conditions
 |  |  |  |  |
When you export custom detail tags with a format type of NUMERIC or DATE, the format switches to a character type by design.
Even when the format is shown as Numeric in the export fields, as shown in the display below, the output is changed to a character format:
Because the length of a character field is set to 32767 characters, campaigns that use numerous custom detail tags might run out of disk space, and the export process might take more time to complete.
For example, suppose that you have an export with 42 columns of export fields, and you add a Date tag field to the export. The export process increases from 30 seconds (without the date tag) to more than 5 minutes (with the date tag), based on an export of 200,000 records.
Click the Hot Fix tab in this note to access the hot fix for this issue.
After you apply the hot fix, the column width for the exported custom detail tag is calculated based on the number of treatments AND the maximum width of the numeric data, which is 32 bytes.
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 | 5.41 | 6.3_M1 | 9.4 TS1M0 | |
| 64-bit Enabled AIX | 5.41 | 6.3_M1 | 9.4 TS1M0 | |||
| 64-bit Enabled Solaris | 5.41 | 6.3_M1 | 9.4 TS1M0 | |||
| HP-UX IPF | 5.41 | 6.3_M1 | 9.4 TS1M0 | |||
| Linux for x64 | 5.41 | 6.3_M1 | 9.4 TS1M0 | |||
| Solaris for x64 | 5.41 | 6.3_M1 | 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#53662| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2014-07-21 10:34:18 |
| Date Created: | 2014-07-21 07:35:55 |