Problem Note 60940: The execution of a campaign group in SAS® Customer Intelligence fails when you use case-sensitive collation
 |  |  |  |  |
In SAS Customer Intelligence Studio, an executed campaign group might fail when you use case-sensitive collation for the Microsoft SQL Server database. When this failure occurs, the following error is shown in the SAS® Customer Intelligence Core log file:
MPRINT(MACDICHE): execute(insert into cdm_design.CI_CONTACT_HISTORY ( PARTY_KEY, CELL_PACKAGE_SK, RESPONSE_TRACKING_CD, CONTACT_HISTORY_STATUS_CD, PACKAGE_HASH_VAL, OPTIMIZATION_BACKFILL_FLG, CONTACT_DTTM, CONTACT_DT ) select PARTY_KEY, CELL_PACKAGE_SK, RESPONSE_TRACKING_CD, CHSTATUS_CD, PACKAGE_HASH_VAL, OPTIMIZATION_BACKFILL_FLG, '2017-07-07 16:46:58.232', '2017-07-07' from SASTMP.CH398BFC28A2F9905880989_001 )by SQLSVR;
ERROR: CLI execute error: [SAS][ODBC 20101 driver][Microsoft SQL Server]Invalid column name 'OPTIMIZATION_BACKFILL_FLG'.
ERROR: CLI execute error: [SAS][ODBC 20101 driver][Microsoft SQL Server]Invalid column name 'OPTIMIZATION_BACKFILL_FLG'.
This error occurs because the optimization_backfill_flg flag is in lowercase in the temporary table.
INSERT INTO SASTMP . CH1120C6C901EDE2B5445B6_001 ( CELL_PACKAGE_SK , RESPONSE_TRACKING_CD , PARTY_KEY , PACKAGE_HASH_VAL , optimization_backfill_flg , CHSTATUS_CD ) VALUES ( ? , ? , ? , ? , ? , ? )
As a workaround, consider using a case-insensitive database.
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 Automation | Solaris for x64 | 6.4 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 |
| Linux for x64 | 6.4 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
| HP-UX IPF | 6.4 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
| 64-bit Enabled Solaris | 6.4 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
| 64-bit Enabled AIX | 6.4 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
| Microsoft® Windows® for x64 | 6.4 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
A fix for this issue for SAS Marketing Automation 6.5 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Z77.html#60940A fix for this issue for SAS Marketing Automation 6.4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/U53.html#60940| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2017-11-03 17:21:12 |
| Date Created: | 2017-08-18 11:30:17 |