SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 62265: The campaign status is set to "successful" even when publishing of the dynamic treatment UDF fails in SAS® Customer Intelligence

DetailsHotfixAboutRate It

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

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Customer Intelligence StudioMicrosoft® Windows® for x646.56.69.4 TS1M6
Microsoft Windows 8 Enterprise 32-bit6.56.69.4 TS1M6
Microsoft Windows 8 Enterprise x646.56.69.4 TS1M6
Microsoft Windows 8 Pro 32-bit6.56.69.4 TS1M6
Microsoft Windows 8 Pro x646.56.69.4 TS1M6
Microsoft Windows 8.1 Enterprise 32-bit6.56.69.4 TS1M6
Microsoft Windows 8.1 Enterprise x646.56.69.4 TS1M6
Microsoft Windows 8.1 Pro 32-bit6.56.69.4 TS1M6
Microsoft Windows 8.1 Pro x646.56.69.4 TS1M6
Microsoft Windows 106.56.69.4 TS1M6
Microsoft Windows Server 20086.56.69.4 TS1M6
Microsoft Windows Server 2008 R26.56.69.4 TS1M6
Microsoft Windows Server 2008 for x646.56.69.4 TS1M6
Microsoft Windows Server 2012 Datacenter6.56.69.4 TS1M6
Microsoft Windows Server 2012 R2 Datacenter6.56.69.4 TS1M6
Microsoft Windows Server 2012 R2 Std6.56.69.4 TS1M6
Microsoft Windows Server 2012 Std6.56.69.4 TS1M6
Microsoft Windows Server 20166.56.69.4 TS1M6
Windows 7 Enterprise 32 bit6.56.69.4 TS1M6
Windows 7 Enterprise x646.56.69.4 TS1M6
Windows 7 Home Premium 32 bit6.56.69.4 TS1M6
Windows 7 Home Premium x646.56.69.4 TS1M6
Windows 7 Professional 32 bit6.56.69.4 TS1M6
Windows 7 Professional x646.56.69.4 TS1M6
Windows 7 Ultimate 32 bit6.56.69.4 TS1M6
Windows 7 Ultimate x646.56.69.4 TS1M6
64-bit Enabled AIX6.56.69.4 TS1M6
64-bit Enabled Solaris6.56.69.4 TS1M6
HP-UX IPF6.56.69.4 TS1M6
Linux for x646.56.69.4 TS1M6
Solaris for x646.56.69.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.