Problem Note 44213: Publishing a campaign might cause the errors "Transact error: Unable to commit.." or "Cannot Insert Null.."
 |  |  |  |  |
SAS® Marketing Automation might fail to publish a campaign. When this problem occurs, SAS Marketing Automation writes an error in the SASMarketingAutomationCoreversion.log file similar to one of the two errors below:
ERROR: Transact error: Unable to commit: The statement has been terminated.: The INSERT statement conflicted with the FOREIGN KEY constraint "CELL_PKG_FK3". The conflict occurred in database.
...immediate cause: Error in the stored process or a called macro. com.sas.analytics.crm.error.client.ApplicationException: Macro[MACPTPUB]. SYSDBRC=[-1400] and SYSDBMSG=[ORACLE: ORA-01400: cannot insert NULL in "CDM_DK"."CI_CELL_PACKAGE_TREATMENT_CNT"."TREATMENT_SK"
To work around this issue, first ensure that the option Automatically publish campaigns on subsequent saves is NOT selected. This option is under Reporting Options in the SAS® Management Console Customer Intelligence plug-in when you select Business Context ► Properties ► Options.
Next, manually publish each campaign using SAS® Customer Intelligence Studio in any of the following circumstances:
- before the initial execution of the campaign
- before any subsequent executions if changes have been made to an already published campaign
- after updating counts on a communication node
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 Marketing Automation | Microsoft® Windows® for 64-Bit Itanium-based Systems | 5.3_M3 | 6.1 | 9.3 TS1M2 | |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 5.3_M3 | 6.1 | 9.3 TS1M2 | |||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 5.3_M3 | 6.1 | 9.3 TS1M2 | |||
| Microsoft Windows XP 64-bit Edition | 5.3_M3 | 6.1 | 9.3 TS1M2 | |||
| Microsoft Windows 95/98 | 5.3_M3 | |||||
| Microsoft Windows 2000 Advanced Server | 5.3_M3 | |||||
| Microsoft Windows 2000 Datacenter Server | 5.3_M3 | |||||
| Microsoft Windows 2000 Server | 5.3_M3 | |||||
| Microsoft Windows 2000 Professional | 5.3_M3 | |||||
| Microsoft Windows NT Workstation | 5.3_M3 | |||||
| Microsoft Windows Server 2003 Datacenter Edition | 5.3_M3 | 6.1 | 9.3 TS1M2 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 5.3_M3 | 6.1 | 9.3 TS1M2 | |||
| Microsoft Windows Server 2003 Standard Edition | 5.3_M3 | 6.1 | 9.3 TS1M2 | |||
| Microsoft Windows Server 2003 for x64 | 5.3_M3 | 6.1 | 9.3 TS1M2 | |||
| Microsoft Windows Server 2008 | 5.3_M3 | 6.1 | 9.3 TS1M2 | |||
| Microsoft Windows Server 2008 for x64 | 5.3_M3 | 6.1 | 9.3 TS1M2 | |||
| Microsoft Windows XP Professional | 5.3_M3 | 6.1 | 9.3 TS1M2 | |||
| Windows 7 Enterprise 32 bit | 5.3_M3 | 6.1 | 9.3 TS1M2 | |||
| Windows 7 Enterprise x64 | 5.3_M3 | 6.1 | 9.3 TS1M2 | |||
| Windows 7 Home Premium 32 bit | 5.3_M3 | 6.1 | 9.3 TS1M2 | |||
| Windows 7 Home Premium x64 | 5.3_M3 | 6.1 | 9.3 TS1M2 | |||
| Windows 7 Professional 32 bit | 5.3_M3 | 6.1 | 9.3 TS1M2 | |||
| Windows 7 Professional x64 | 5.3_M3 | 6.1 | 9.3 TS1M2 | |||
| Windows 7 Ultimate 32 bit | 5.3_M3 | 6.1 | 9.3 TS1M2 | |||
| Windows 7 Ultimate x64 | 5.3_M3 | 6.1 | 9.3 TS1M2 | |||
| Windows Millennium Edition (Me) | 5.3_M3 | |||||
| Windows Vista | 5.3_M3 | 6.1 | 9.3 TS1M2 | |||
| Windows Vista for x64 | 5.3_M3 | 6.1 | 9.3 TS1M2 | |||
| 64-bit Enabled AIX | 5.3_M3 | 6.1 | 9.3 TS1M2 | |||
| 64-bit Enabled HP-UX | 5.3_M3 | 6.1 | 9.3 TS1M2 | |||
| 64-bit Enabled Solaris | 5.3_M3 | 6.1 | 9.3 TS1M2 | |||
| HP-UX IPF | 5.3_M3 | 6.1 | 9.3 TS1M2 | |||
| Linux on Itanium | 5.3_M3 | 6.1 | 9.3 TS1M2 | |||
A fix for this issue for SAS Marketing Automation 5.3_M3 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/C18.html#44213| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2011-12-12 09:08:56 |
| Date Created: | 2011-09-07 06:08:25 |