SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 58399: The communication status code is incorrect in the CI_Communication table for SAS® Marketing Automation

DetailsHotfixAboutRate It

The code _30, which indicates a status of Failed, might be visible in the COMMUNICATION_STATUS_CD column in the CI_COMMUNICATION table after a campaign execution fails. However, the expected code in the SAS® Customer Intelligence Common Data Model (CDM) when campaign execution fails is _32, which indicates a status of Future (meaning that the campaign has not executed properly yet). The code __30 is no longer used in the CDM. This code is valid only to show the status in the application's user interface, but it should not be returned in the COMMUNICATION_STATUS_CD column.

This problem might occur when the following conditions occur:

  1. A campaign uses a Communication node.
  2. The Communication node has one or more export definitions.
  3. The campaign successfully executes. After the execution, you open the export definition file that is defined in the Communication node.
  4. You re-execute the campaign, and it fails because the export definition file is open.

At this point, the _30 code might appear in the COMMUNICATION_STATUS_CD column.

There is no solution or workaround for this problem.

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.49.4 TS1M2
64-bit Enabled AIX6.49.4 TS1M2
64-bit Enabled Solaris6.49.4 TS1M2
HP-UX IPF6.49.4 TS1M2
Linux for x646.49.4 TS1M2
Solaris for x646.49.4 TS1M2
* 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.