Problem Note 41829: A SAS® Marketing Optimization validation might fail with the error "Duplicate combination detected"
 |  |  |  |  |
If you create an optimization group in SAS Marketing Optimization and you validate it, the validation might fail with the following error:
ERROR:(mo_validate_input_data)- Duplicate combination detected in CUSTOMERCONTROL table where NUMERIC_MEASURE=score_ , CAMPAIGN_CD=0610_1 , COMMUNICATION_CD=multi , and CELL_CD=female.
This problem might occur if you use score values from SAS® Marketing Automation that have numbers as suffixes. SAS Marketing Optimization incorrectly replaces these numeric suffixes with underscores (_), as shown in the following examples:
- Score1 becomes Score_.
- Score2 becomes Score_.
You lose the uniqueness of the score values. Therefore, the software generates the message regarding duplicates.
As a workaround, you should ensure that your score values do not depend on numbers for uniqueness.
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 Marketing Optimization | Microsoft® Windows® for x64 | 5.3_M3 | 5.4 | 9.2 TS2M3 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Datacenter Edition | 5.3_M3 | 5.4 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 5.3_M3 | 5.4 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 5.3_M3 | 5.4 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 for x64 | 5.3_M3 | 5.4 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 | 5.3_M3 | 5.4 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 for x64 | 5.3_M3 | 5.4 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 5.3_M3 | 5.4 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows 7 Enterprise 32 bit | 5.3_M3 | 5.4 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows 7 Enterprise x64 | 5.3_M3 | 5.4 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows 7 Home Premium 32 bit | 5.3_M3 | 5.4 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows 7 Home Premium x64 | 5.3_M3 | 5.4 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows 7 Professional 32 bit | 5.3_M3 | 5.4 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows 7 Professional x64 | 5.3_M3 | 5.4 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows 7 Ultimate 32 bit | 5.3_M3 | 5.4 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows 7 Ultimate x64 | 5.3_M3 | 5.4 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows Vista | 5.3_M3 | 5.4 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows Vista for x64 | 5.3_M3 | 5.4 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| 64-bit Enabled AIX | 5.3_M3 | 5.4 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| 64-bit Enabled HP-UX | 5.3_M3 | 5.4 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| 64-bit Enabled Solaris | 5.3_M3 | 5.4 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| HP-UX IPF | 5.3_M3 | 5.4 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Linux for x64 | 5.3_M3 | 5.4 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Solaris for x64 | 5.3_M3 | 5.4 | 9.2 TS2M3 | 9.2 TS2M3 | ||
A fix for this issue for SAS Marketing Automation 5.3_M3 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/C18.html#41829| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2011-05-18 08:54:49 |
| Date Created: | 2010-12-10 09:50:21 |