Problem Note 45809: SAS® Marketing Automation returns the error "Teradata row not delivered (trget): Transaction ABORTed due to deadlock" when you publish a campaign
 |  |  |  |  |
When you execute or publish a campaign to the Common Data Model, SAS Marketing Automation might fail to publish and return one of the following errors in the log:
SYSCC=100000
MAError=864
MAMsg=Macro[MATMTUDF]. SYSDBRC=[2631] and SYSDBMSG=[TERADATA: Transaction ABORTed due to Deadlock ]
When this problem occurs, the client, SAS® Customer Intelligence Studio, might also become unresponsive.
The behavior occurs when SAS Marketing Automation sends a request to Teradata to insert records in a table that is already locked.
Click the Hot Fix tab in this note to access the hot fix for this issue.
After you apply the hot fix, follow the configuration recommendations that are documented in SAS Note 44812, "SAS® Customer Intelligence campaigns might fail or become unresponsive."
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Customer Intelligence Core Mid-Tier | Solaris for x64 | 5.4 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 |
| Linux for x64 | 5.4 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| HP-UX IPF | 5.4 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| 64-bit Enabled Solaris | 5.4 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| 64-bit Enabled AIX | 5.4 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft® Windows® for x64 | 5.4 | 6.1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
A fix for this issue for SAS Marketing Automation 5.4_M1 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/E08.html#45809A fix for this issue for SAS Marketing Automation 5.41 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/E88.html#45809| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2012-04-10 08:54:44 |
| Date Created: | 2012-02-27 09:54:30 |