If a campaign execution fails to publish in SAS Customer Intelligence Studio, new rows are not added to the Common Data Model tables CI_COMMUNICATION or CI_CELL_PACKAGE after the next successful campaign execution.

The problem occurs in a scenario similar to the following:

1. You create a campaign by selecting Cell ► Communication ► Process (Process node). The campaign should look similar to the following:
   

   

   Note: In this image, Select is a node.

2. Then you execute the campaign.
   

   At this point an entry is made in the table that shows a value of 1 for COMMUNICATION_OCCURRENCE_NO.

3. The Process node fails, which causes the campaign execution to fail as well. When that happens, two entries then appear in the CI_CELL_PACKAGE and CI_COMMUNICATION tables. The tables have COMMUNICATION_OCCURRENCE_NO values of 1 and 2, and a COMMUNICATION_STATUS_CD value of _11.
   

   

   In order for the campaign to execute successfully, you need to modify the Process node again.

   At this point, a third entry should be added to the tables that shows a value of 3 for COMMUNICATION_OCCURRENCE_NO. However, no such entry is added to the tables. The campaign is flagged to indicate that the publish is completed for every execution, but the flag is not reset when an error occurs.

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

Operating System and Release Information

A fix for this issue for SAS Marketing Automation 6.3 is available at:

A fix for this issue for SAS Marketing Automation 6.1_M1 is available at: