Problem Note 58399: The communication status code is incorrect in the CI_Communication table for SAS® Marketing Automation
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:
- A campaign uses a Communication node.
- The Communication node has one or more export definitions.
- The campaign successfully executes. After the execution, you open the export definition file that is defined in the Communication node.
- 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
SAS System | SAS Marketing Automation | Microsoft® Windows® for x64 | 6.4 | | 9.4 TS1M2 | |
64-bit Enabled AIX | 6.4 | | 9.4 TS1M2 | |
64-bit Enabled Solaris | 6.4 | | 9.4 TS1M2 | |
HP-UX IPF | 6.4 | | 9.4 TS1M2 | |
Linux for x64 | 6.4 | | 9.4 TS1M2 | |
Solaris for x64 | 6.4 | | 9.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.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2016-11-15 16:43:20 |
Date Created: | 2016-06-14 15:25:47 |