Problem Note 19816: If a subject ID description contains blank spaces, then one column is created for each word in that description
When the subject ID in an information map contains blanks, the
extract/transform/load (ETL) operation between SAS® Marketing Automation
and SAS® Marketing Optimization ETL fails and creates a column for each
word in the description.
For example, the description "Surrogate Key For A Unique Client"
generates a table that contains one variable for each word:
Variable
======
Surrogate
Key
For
A
Unique
Client
To avoid this problem, do not include blank spaces in your subject ID
descriptions.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS Marketing Optimization Server | Microsoft Windows XP Professional | 9 TS M0 | |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9 TS M0 | |
| Microsoft Windows NT Workstation | 9 TS M0 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9 TS M0 | |
| Microsoft Windows Server 2003 Standard Edition | 9 TS M0 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9 TS M0 | |
| Microsoft Windows 2000 Professional | 9 TS M0 | |
| Microsoft Windows 2000 Server | 9 TS M0 | |
| Microsoft Windows 2000 Advanced Server | 9 TS M0 | |
| Microsoft Windows 2000 Datacenter Server | 9 TS M0 | |
| Solaris | 9 TS M0 | |
| z/OS | 9 TS M0 | |
| 64-bit Enabled Solaris | 9 TS M0 | |
| Linux | 9 TS M0 | |
| 64-bit Enabled HP-UX | 9 TS M0 | |
| HP-UX | 9 TS M0 | |
| HP-UX IPF | 9 TS M0 | |
| OpenVMS Alpha | 9 TS M0 | |
| 64-bit Enabled AIX | 9 TS M0 | |
| Tru64 UNIX | 9 TS M0 | |
| AIX | 9 TS M0 | |
*
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 |
| Topic: | Analytics ==> Mathematical Optimization
|
| Date Modified: | 2007-05-21 15:57:02 |
| Date Created: | 2007-03-22 08:22:50 |
