SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 57561: Teradata deadlock issues occur when you concurrently publish multiple SAS® Customer Intelligence campaigns to the Common Data Model

DetailsHotfixAboutRate It

When you concurrently publish multiple SAS Customer Intelligence campaigns to the Common Data Model, a deadlock situation might occur. The following error message is shown in the SASCustIntellCore6.x.log file:

2015-12-20 11:05:26,214 ERROR [CIExec-5] [cb823ebbce479add:-1314295:151be91f38f:-68ae] [sasdemo] ics.crm.custdata.ejb.MAPublishResultData - TID[CIExec-5] Stored process exception, MA Return Code: 829, MA Return Message: Macro[MACOMUDF]. SYSDBRC=[2631] and SYSDBMSG=[TERADATA: Transaction ABORTed due to deadlock ], SAS Return Code: 100000

As a workaround, you can 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 FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Customer Intelligence Core Mid-TierSolaris for x646.3
Linux for x646.3
HP-UX IPF6.3
64-bit Enabled Solaris6.3
64-bit Enabled AIX6.3
Microsoft® Windows® for x646.3
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.