SUPPORT / SAMPLES & SAS NOTES
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 | ||