Problem Note 60713: The DELETED_FLG column in the CI_CELL_PACKAGE table is not updated correctly for holdout groups
 |  |  |  |  |
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:
- 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).
- 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 Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Marketing Automation | Microsoft® Windows® for x64 | 6.3 | 6.5 | 9.4 TS1M1 | 9.4 TS1M3 |
| 64-bit Enabled AIX | 6.3 | 6.5 | 9.4 TS1M1 | 9.4 TS1M3 | ||
| 64-bit Enabled Solaris | 6.3 | 6.5 | 9.4 TS1M1 | 9.4 TS1M3 | ||
| HP-UX IPF | 6.3 | 6.5 | 9.4 TS1M1 | 9.4 TS1M3 | ||
| Linux for x64 | 6.3 | 6.5 | 9.4 TS1M1 | 9.4 TS1M3 | ||
| Solaris for x64 | 6.3 | 6.5 | 9.4 TS1M1 | 9.4 TS1M3 | ||
A fix for this issue for SAS Marketing Automation 6.3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/R60.html#60713| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2017-08-28 10:10:47 |
| Date Created: | 2017-07-04 10:44:12 |