Problem Note 64731: Executing the SAS® Customer Intelligence utility -releasetables causes all campaigns to be republished
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:
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
SAS System | SAS Customer Intelligence Utilities | Microsoft® Windows® for x64 | 6.4 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 |
64-bit Enabled AIX | 6.4 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 |
64-bit Enabled Solaris | 6.4 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 |
HP-UX IPF | 6.4 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 |
Linux for x64 | 6.4 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 |
Solaris for x64 | 6.4 | 6.6 | 9.4 TS1M2 | 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: | 2019-10-23 14:47:07 |
Date Created: | 2019-09-05 05:09:58 |