Problem Note 55674: Campaigns fail with deadlock errors when you publish user-defined fields in the Communication node to the Reporting Common Data Model
 |  |  |  |  |
When you execute SAS® Customer Intelligence campaigns, the publish process might fail intermittently with the following error:
ERROR: Teradata insert: Transaction ABORTed due to deadlock. SQL statement was: USING ("COMMUNICATION_SK" DECIMAL(10),"CHAR_UDF_NM" VARCHAR (60),"CHAR_UDF_VAL" VARCHAR (500),"CHAR_EXT_COLUMN_NM"
VARCHAR (30),"PROCESSED_DTTM" CHAR (26))INSERT INTO cdm."CI_COMMUNICATION_CHAR_UDF" ("COMMUNICATION_SK","CHAR_UDF_NM","CHAR_UDF_VAL","CHAR_EXT_COLUMN_NM","PROCESSED_DTTM") VALUES
(:"COMMUNICATION_SK",:"CHAR_UDF_NM",:"CHAR_UDF_VAL",:"CHAR_EXT_COLUMN_NM",:"PROCESSED_DTTM"). Insert substitution values are not shown.
NOTE: Statements not processed because of errors noted above.
This problem occurs when you publish user-defined fields in the Communication node to the Reporting Common Data Model.
In this situation, the campaign often completes successfully if you re-execute it.
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 Processes | Microsoft® Windows® for x64 | 5.41 | 6.3 | 9.4 TS1M0 | |
| 64-bit Enabled AIX | 5.41 | 6.3 | 9.4 TS1M0 | |||
| 64-bit Enabled HP-UX | 5.41 | 6.3 | 9.4 TS1M0 | |||
| 64-bit Enabled Solaris | 5.41 | 6.3 | 9.4 TS1M0 | |||
| HP-UX IPF | 5.41 | 6.3 | 9.4 TS1M0 | |||
| Linux for x64 | 5.41 | 6.3 | 9.4 TS1M0 | |||
| Solaris for x64 | 5.41 | 6.3 | 9.4 TS1M0 | |||
A fix for this issue for SAS Marketing Automation 5.41 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/E88.html#55674| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2015-04-29 14:16:40 |
| Date Created: | 2015-04-29 09:58:32 |