SUPPORT / SAMPLES & SAS NOTES
Problem Note 60680: A Teradata deadlock occurs and generates an error when you publish multiple campaigns to the SAS® Customer Intelligence Common Data Model
 |  |  |  |  |
A deadlock on the CI_COMMUNICATION table might occur when you publish multiple campaigns to the common data model. When this situation occurs, the following error message is displayed in the SASCustIntellCore6.x.log file:
ERROR: Teradata update: Transaction ABORTed due to deadlock. SQL statement was: USING ("COMMUNICATION_SK" DECIMAL(10),"COMMUNICATION_STATUS_CD" VARCHAR (3),
"EXPORT_DTTM" CHAR (26),"PROCESSED_DTTM" CHAR (26))UPDATE CDM."CI_COMMUNICATION" SET "COMMUNICATION_SK"=:"COMMUNICATION_SK",
"COMMUNICATION_STATUS_CD"=:"COMMUNICATION_STATUS_CD",
"EXPORT_DTTM"=CAST(:"EXPORT_DTTM" AS TIMESTAMP(6)),"PROCESSED_DTTM"=CAST(:"PROCESSED_DTTM" AS TIMESTAMP(6)) WHERE CURRENT.
Insert substitution values are not shown.
The SAS System stopped processing this step because of errors.
There were 1 observations read from the data set CDM.CI_COMMUNICATION.
The data set CDM.CI_COMMUNICATION has been updated. There were 0 observations rewritten, 0 observations added and 0 observations deleted.
ERROR: ROLLBACK issued due to errors for data set CDM.CI_COMMUNICATION.DATA.
"EXPORT_DTTM" CHAR (26),"PROCESSED_DTTM" CHAR (26))UPDATE CDM."CI_COMMUNICATION" SET "COMMUNICATION_SK"=:"COMMUNICATION_SK",
"COMMUNICATION_STATUS_CD"=:"COMMUNICATION_STATUS_CD",
"EXPORT_DTTM"=CAST(:"EXPORT_DTTM" AS TIMESTAMP(6)),"PROCESSED_DTTM"=CAST(:"PROCESSED_DTTM" AS TIMESTAMP(6)) WHERE CURRENT.
Insert substitution values are not shown.
The SAS System stopped processing this step because of errors.
There were 1 observations read from the data set CDM.CI_COMMUNICATION.
The data set CDM.CI_COMMUNICATION has been updated. There were 0 observations rewritten, 0 observations added and 0 observations deleted.
ERROR: ROLLBACK issued due to errors for data set CDM.CI_COMMUNICATION.DATA.
To work around this issue, reduce the number of campaigns that you concurrently publish.
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 Reporting Mid-Tier | Solaris for x64 | 6.3 | 9.4 TS1M1 | ||
| Linux for x64 | 6.3 | 9.4 TS1M1 | ||||
| HP-UX IPF | 6.3 | 9.4 TS1M1 | ||||
| 64-bit Enabled Solaris | 6.3 | 9.4 TS1M1 | ||||
| 64-bit Enabled AIX | 6.3 | 9.4 TS1M1 | ||||
| Microsoft® Windows® for x64 | 6.3 | 9.4 TS1M1 | ||||