SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 64731: Executing the SAS® Customer Intelligence utility -releasetables causes all campaigns to be republished

DetailsHotfixAboutRate It

Executing the SAS Customer Intelligence -releasetables utility in a command similar to the following opens all existing campaigns in the background, re-saves them, and then automatically republishes them:

sasciutils -releasetables -userid sasdemo -password your-password -deldate 30MAY2019 -bcname "bc-name"

This behavior occurs when the setting Automatically publish campaigns on subsequent save is enabled. This setting is located on the Settings tab in the Business Context Properties window, as shown below:

Automatically publish campaigns on subsequent save

Republishing all campaigns can have an negative impact on the performance, and it might cause inactive campaigns to be republished as well.

Click the Hot Fix tab in this note to access the hot fix for this issue.

After you apply the hot fix, you can avoid the automatic republishing of campaigns by using the new parameter -publish false, as shown below:

sasciutils -releasetables -userid sasdemo -password your-password -deldate 30MAY2019 -bcname "bc-name" -publish false

Note: Using this new parameter does not update the date in the LAST_MODIFIED_DTTM column of the Common Data Model table CI_CAMPAIGN. Instead, the column keeps the last time that the campaign was executed or changed by a user.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Customer Intelligence UtilitiesMicrosoft® Windows® for x646.46.69.4 TS1M29.4 TS1M6
64-bit Enabled AIX6.46.69.4 TS1M29.4 TS1M6
64-bit Enabled Solaris6.46.69.4 TS1M29.4 TS1M6
HP-UX IPF6.46.69.4 TS1M29.4 TS1M6
Linux for x646.46.69.4 TS1M29.4 TS1M6
Solaris for x646.46.69.4 TS1M29.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.