Re-executing a communication in SAS Customer Intelligence after a failing execution of the campaign will not update COMMUNICATION_OCCURRENCE_NO correctly.

To re-create this situation, follow these steps:

1. Create a simple campaign by selecting Select Node ► Cell Node ► Communication Node ► Custom Diagram Tools.
2. Execute the campaign.
3. The Execution History in SAS Customer Intelligence Studio correctly shows Occurrence Number 1, 2, and so on, along with Status Successful.
4. The CI_COMMUNICATION table correctly shows COMMUNICATION_OCCURRENCE_NO 1, 2, and so on.
5. Now make the Custom Diagram Tools fail on purpose.
6. Execute the campaign again. This time, the execution returns an error because the Custom Diagram Tools failed to execute.
7. The Execution History still shows successful executions.
8. Correct the error for the Custom Diagram Tools so that the campaign executes successfully again.
9. Then, execute the communication and not the campaign.
10. Execute the communication two times. The Execution History in SAS Customer Intelligence Studio is still correct:

When you execute a campaign that fails (for this example, COMMUNICATION_OCCURRENCE_NO 7) and then re-execute the next successful communication (for this example, COMMUNICATION_OCCURRENCE_NO 8), the CI_COMMUNICATION and CI_CELL_PACKAGE tables are incorrect. As shown below, the next successful execution, COMMUNICATION_OCCURRENCE_NO 8, is missing in CI_CELL_PACKAGE and CI_COMMUNICATION tables.

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: