Deadlock issues are reported for various SAS Marketing Automation macros when you are publishing to the Common Data Model. This issue is particularly prevalent when the Common Data Model is held in a Teradata database. You might see the following types of error messages for various macros in the SASMarketingAutomationCore5.4.log file:

SYSDBRC=[2631] and SYSDBMSG=[TERADATA: Transaction ABORTed due to deadlock ]:
MA error code 829: Vendor code 100000

Macro[MACDIUPL].
ERROR: Teradata insert:
Transaction ABORTed due to deadlock. SQL statement was: USING ("CELL_PACKAGE_SK"

Click the Hot Fix tab in this note to access the hot fix for this issue.

Applying the hot fix enables better concurrent updates to the Common Data Model.

Operating System and Release Information

A fix for this issue for SAS Marketing Automation 6.1_M1 is available at:

A fix for this issue for SAS Marketing Automation 5.41 is available at: