Problem Note 55673: The error "Publish failed to insert MARKETING_CELL records" occurs when you publish campaigns in SAS® Customer Intelligence
 |  |  |  |  |
When you execute SAS Customer Intelligence campaigns, the publish process might fail intermittently with the following error:
YYYY-MM-DD hh:mm:ss,xxx ERROR Session[8521c194d1676871:-37efa281:1412638f861:-6038] User[User Name] SID[8521c194d1676871:-37efa281:1412638f861:-6038] com.sas.analytics.crm.custdata.ejb.MAPublishResultData TID[CIExec-5] Stored process exception, MA Return Code: 806, MA Return Message: Macro[PUBLISH_MASTER]. Publish failed to insert MARKETING_CELL records with reason code SYSDBRC=[2631] and SYSDBMSG=[TERADATA: Transaction ABORTed due to Deadlock ], SAS Return Code: 100000
This error occurs when the Reporting Common Data Model is deployed to a Teradata database.
In addition, the log contains a note similar to the following:
NOTE: The SQL statement cannot be executed directly against the database because it involves heterogeneous data sources.
If you re-execute the campaign, it should run to completion.
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#55673| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2015-04-29 14:12:56 |
| Date Created: | 2015-04-29 09:32:42 |