SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 60713: The DELETED_FLG column in the CI_CELL_PACKAGE table is not updated correctly for holdout groups

DetailsHotfixAboutRate It

In the CI_CELL_PACKAGE table of the SAS® Customer Intelligence Common Data Model, the DELETED_FLG column might not be updated correctly for holdout groups.

This problem occurs under the following scenario:

  1. You execute a selection campaign with a holdout group that is defined in the Communication node. The common data model is updated correctly as expected with two rows added to the CI_CELL_PACKAGE table (one for the marketing cell and one for the holdout group).

  2. You then delete the contact history for the campaign by highlighting the communication on the Execution page (History tab) in SAS® Customer Intelligence Studio and clicking the trash-can icon. The correct rows in the Contact History table are deleted as expected and the DELETED_FLG column in the CI_CELL_PACKAGE table for the marketing cell is set to Y (as expected). However, the  DELETED_FLG column in the CI_CELL_PACKAGE table for the holdout group row is still set to N instead of Y.

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



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Marketing AutomationMicrosoft® Windows® for x646.36.59.4 TS1M19.4 TS1M3
64-bit Enabled AIX6.36.59.4 TS1M19.4 TS1M3
64-bit Enabled Solaris6.36.59.4 TS1M19.4 TS1M3
HP-UX IPF6.36.59.4 TS1M19.4 TS1M3
Linux for x646.36.59.4 TS1M19.4 TS1M3
Solaris for x646.36.59.4 TS1M19.4 TS1M3
* 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.