SUPPORT / SAMPLES & SAS NOTES
Problem Note 60660: The status for the DELETED_FLG column is updated incorrectly in the CI_CELL_PACKAGE table in SAS® Marketing Automation
 |  |  |  |  |
The DELETED_FLG column in the CI_CELL_PACKAGE table might be incorrectly set to Y under the following scenario:
- A selection campaign is executed twice. At this point, the DELETED_FLG column in the CI_CELL_PACKAGE table is correctly set to N.
- The campaign is exported as an SPK package. Then, this campaign is imported into a different folder using the same SPK package. Now there are two campaigns shown in SAS® Customer Intelligence Studio with the same name and campaign code.
- The newly imported campaign is executed once.
- Then, the execution occurrence of the newly imported campaign is deleted by highlighting it and clicking the trash-can icon. (The execution occurrence is on the History tab of the Execution page in SAS Customer Intelligence Studio.)
In the CI_CELL_PACKAGE table, the DELETED_FLG column in the row that corresponds to the execution of the newly imported column is correctly updated as Y. However, the DELETED_FLG column in the row that corresponds to the original execution of the campaign (step 1 above) is also (incorrectly) set to 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.5 | |||
| 64-bit Enabled AIX | 6.5 | |||||
| 64-bit Enabled Solaris | 6.5 | |||||
| HP-UX IPF | 6.5 | |||||
| Linux for x64 | 6.5 | |||||
| Solaris for x64 | 6.5 | |||||