Problem Note 55432: The execution of an optimization group in SAS® Customer Intelligence Studio might fail when one communication contains a control group
 |  |  |  |  |
The execution of an optimization group in SAS Customer Intelligence Studio might fail with the following error message in the SASApp_PooledWSServer.log:
2014-09-01T16:34:31,047 ERROR [00000044] :emattera@CORP - ERROR: Ambiguous reference, column OPTIMIZATION_BACKFILL_FLG is in more than one table. 2014-09-01T16:34:31,048 ERROR [00000044] :emattera@CORP - ERROR: SQL View WORK.INTABLE_1_VW could not be processed. 2014-09-01T16:34:31,058 ERROR [00000046] :emattera@CORP - ERROR: Column cccid could not be found in the table/view identified with the correlation name S. 2014-09-01T16:34:31,058 ERROR [00000046] :emattera@CORP - ERROR: Column cccid could not be found in the table/view identified with the correlation name S. 2014-09-01T16:34:31,058 ERROR [00000046] :emattera@CORP - ERROR: Column cccid could not be found in the table/view identified with the correlation name S. 2014-09-01T16:34:31,059 ERROR [00000046] :emattera@CORP - ERROR: Expression using equals (=) has components that are of different data types. 2014-09-01T16:34:31,059 ERROR [00000046] :emattera@CORP - ERROR: The following columns were not found in the contributing tables: CUMULUSID, OPTIMIZATION_BACKFILL_FLG, PACKAGE_HASH_VAL, RESPTRACKING_CD.
This problem occurs when at least one communication contains a control group.
There is no workaround other than to avoid using controls groups in an optimization group.
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 Studio | Microsoft® Windows® for x64 | 6.1_M1 | 6.4 | 9.4 TS1M0 | |
| Microsoft Windows 8 Enterprise x64 | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| Microsoft Windows 8 Pro x64 | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| Microsoft Windows 8.1 Enterprise 32-bit | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| Microsoft Windows 8.1 Enterprise x64 | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| Microsoft Windows 8.1 Pro | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| Microsoft Windows 8.1 Pro 32-bit | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2008 R2 | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2008 for x64 | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 Datacenter | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 R2 Datacenter | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 R2 Std | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 Std | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| Windows 7 Enterprise x64 | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| Windows 7 Professional x64 | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| 64-bit Enabled AIX | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| 64-bit Enabled Solaris | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| HP-UX IPF | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| Linux for x64 | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| Solaris for x64 | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
A fix for this issue for SAS Marketing Automation 6.3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/R60.html#55432A fix for this issue for SAS Marketing Automation 6.1_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/K78.html#55432| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2015-03-25 14:16:03 |
| Date Created: | 2015-03-24 10:44:38 |