Problem Note 62265: The campaign status is set to "successful" even when publishing of the dynamic treatment UDF fails in SAS® Customer Intelligence
SAS Customer Intelligence campaign treatments might contain dynamic treatment user-defined fields (UDF) that are published to the common data model (CDM) when the campaign is executed.
If the publishing of the dynamic treatment UDF fails for some reason, the campaign execution status (available by selecting Execution ► Tab History) is updated to successful as shown in the example below:
Although the status indicates success, the campaign actually fails.
If the publishing process fails, you might see an error similar to the following in the SASCustIntelCore6.x.log file:
com.sas.analytics.crm.error.client.StoredProcessException: Macro[MADTTERA] Error inserting Treatment records to [CI_PACKAGE_X_TREATMENT]. SQLXRC=[2631] and
SQLXMSG=[Transaction ABORTed due to deadlock ]. Check the log for details.
2018-03-06 17:13:05,037 ERROR [CITaskCleanup-3] [62579a0cc0a59d7e:-4e729783:161fc744dd0:524] [user] s.analytics.crm.flow.MACommunicationNode -
Dynamic Treatment Custom Detail Update Stored Process Failed].
From a data and execution perspective, the campaign has failed, and it rolls back any postings and updates to the CDM. However, the status is still set to successful.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Note: After you apply the hot fix, the following new Java argument is introduced:
-Dcom.sas.ci.setOccurrenceFailOnDTFail=true
This new argument gives you the option to change the default behavior so that the execution status will show a status of failed.
You can add the new argument, as follows:
- In Microsoft Windows operating environments, open the wrapper.conf file, which is available in the SAS-configuration-directory\Lev1\Web\WebAppServer\SASServer6_1\conf directory. In wrapper.conf, add the argument as shown below:
wrapper.java.additional.XX=-Dcom.sas.ci.setOccurrenceFailOnDTFail=true
Note: In the wrapper.java.additional.XX property, XX specifies the next number in the sequence that already exists in the file. Modify XX to be the next number in that sequence.
- Under Linux and other UNIX operating environments, open the setenv.sh file, which is located in the SAS-configuration-directory/Lev1/Web/WebAppServer/SASServer6_1/bin directory. In setenv.sh, add the new argument as shown below:
JAVA_OPTS="$JAVA_OPTS =-Dcom.sas.ci.setOccurrenceFailOnDTFail=true"
After you add the arguments to the appropriate file for your operating system, restart the middle tier in order for the settings to take effect.
Operating System and Release Information
SAS System | SAS Customer Intelligence Studio | Microsoft® Windows® for x64 | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows 8 Enterprise 32-bit | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows 8 Enterprise x64 | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows 8 Pro 32-bit | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows 8 Pro x64 | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows 8.1 Enterprise 32-bit | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows 8.1 Enterprise x64 | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows 8.1 Pro 32-bit | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows 8.1 Pro x64 | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows 10 | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows Server 2008 | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows Server 2008 R2 | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows Server 2008 for x64 | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows Server 2012 Datacenter | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows Server 2012 R2 Datacenter | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows Server 2012 R2 Std | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows Server 2012 Std | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows Server 2016 | 6.5 | 6.6 | | 9.4 TS1M6 |
Windows 7 Enterprise 32 bit | 6.5 | 6.6 | | 9.4 TS1M6 |
Windows 7 Enterprise x64 | 6.5 | 6.6 | | 9.4 TS1M6 |
Windows 7 Home Premium 32 bit | 6.5 | 6.6 | | 9.4 TS1M6 |
Windows 7 Home Premium x64 | 6.5 | 6.6 | | 9.4 TS1M6 |
Windows 7 Professional 32 bit | 6.5 | 6.6 | | 9.4 TS1M6 |
Windows 7 Professional x64 | 6.5 | 6.6 | | 9.4 TS1M6 |
Windows 7 Ultimate 32 bit | 6.5 | 6.6 | | 9.4 TS1M6 |
Windows 7 Ultimate x64 | 6.5 | 6.6 | | 9.4 TS1M6 |
64-bit Enabled AIX | 6.5 | 6.6 | | 9.4 TS1M6 |
64-bit Enabled Solaris | 6.5 | 6.6 | | 9.4 TS1M6 |
HP-UX IPF | 6.5 | 6.6 | | 9.4 TS1M6 |
Linux for x64 | 6.5 | 6.6 | | 9.4 TS1M6 |
Solaris for x64 | 6.5 | 6.6 | | 9.4 TS1M6 |
*
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: | 2018-07-16 09:45:13 |
Date Created: | 2018-05-03 12:25:34 |