In SAS^® Customer Intelligence Studio, the column APPROVAL_GIVEN_BY_NM in the table CI_CAMPAIGN contains the wrong value when you publish the table manually to the common data model.

This problem happens when you perform steps similar to the following:

1. Create an approval campaign as UserA and request approval.


2. Log off from SAS Customer Intelligence Studio. Then, log on again as UserB and grant approval.


3. Log off. Then, log on as UserA again.


4. Manually publish the campaign.

After you perform these steps, the column APPROVAL_GIVEN_BY_NM in table CI_CAMPAIGN shows the value UserA, which is wrong. It should show UserB.

To avoid this problem, execute the campaign rather than manually publishing. Then, the column APPROVAL_GIVEN_BY_NM displays the correct value (UserB).  

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.6 is available at: