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
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 |
*
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.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2011-12-12 09:08:56 |
Date Created: | 2011-09-07 06:08:25 |