Problem Note 60853: An error occurs and the contact-history insert step fails when you optimize campaign groups in SAS® Marketing Automation
 |  |  |  |  |
When you optimize campaigns groups in SAS Marketing Automation, the contact-history insert step might fail because the optimization_backfill_flg column in the CI_CONTACT_HISTORY table contains numeric values instead of characters. Along with this failure, the following error is displayed in the SASCustIntelCore log file:
MPRINT(MACDICHE): execute(insert into mcmprdm5.CI_CONTACT_HISTORY ( INDIV_ID,OPER_DIVN_NBR, CELL_PACKAGE_SK, RESPONSE_TRACKING_CD,
CONTACT_HISTORY_STATUS_CD, PACKAGE_HASH_VAL, OPTIMIZATION_BACKFILL_FLG,
CONTACT_DTTM, CONTACT_DT ) select INDIV_ID,OPER_DIVN_NBR, CELL_PACKAGE_SK,
RESPONSE_TRACKING_CD, CHSTATUS_CD, PACKAGE_HASH_VAL, OPTIMIZATION_BACKFILL_FLG,
TO_TIMESTAMP('2017-06-29 12:47:06.983','YYYY-MM-DD HH24:MI:SS.FF'), TO_DATE(
'2017-06-29' , 'YYYY-MM-DD' ) from MCMPSASBLMA.CH4FC05CBE8FD457C5E0AB3_001 )by ORACLE;
ERROR: ORACLE execute error: ORA-12899: value too large for column
"MCMPRDM5"."CI_CONTACT_HISTORY"."OPTIMIZATION_BACKFILL_FLG" (actual: 8, maximum:
1).
CONTACT_HISTORY_STATUS_CD, PACKAGE_HASH_VAL, OPTIMIZATION_BACKFILL_FLG,
CONTACT_DTTM, CONTACT_DT ) select INDIV_ID,OPER_DIVN_NBR, CELL_PACKAGE_SK,
RESPONSE_TRACKING_CD, CHSTATUS_CD, PACKAGE_HASH_VAL, OPTIMIZATION_BACKFILL_FLG,
TO_TIMESTAMP('2017-06-29 12:47:06.983','YYYY-MM-DD HH24:MI:SS.FF'), TO_DATE(
'2017-06-29' , 'YYYY-MM-DD' ) from MCMPSASBLMA.CH4FC05CBE8FD457C5E0AB3_001 )by ORACLE;
ERROR: ORACLE execute error: ORA-12899: value too large for column
"MCMPRDM5"."CI_CONTACT_HISTORY"."OPTIMIZATION_BACKFILL_FLG" (actual: 8, maximum:
1).
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 | Microsoft® Windows® for x64 | 6.4 | 6.6 | 9.4 TS1M2 | 9.4 TS1M4 |
| 64-bit Enabled AIX | 6.4 | 6.6 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| 64-bit Enabled Solaris | 6.4 | 6.6 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| HP-UX IPF | 6.4 | 6.6 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Linux for x64 | 6.4 | 6.6 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Solaris for x64 | 6.4 | 6.6 | 9.4 TS1M2 | 9.4 TS1M4 | ||
A fix for this issue for SAS Marketing Automation 6.5 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Z77.html#60853A fix for this issue for SAS Marketing Automation 6.4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/U53.html#60853| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2017-11-03 17:19:04 |
| Date Created: | 2017-07-31 15:38:12 |