Problem Note 66737: The column APPROVAL_GIVEN_BY_NM contains the wrong value when you publish manually to the SAS® Customer Intelligence Common Data Model
 |  |  |  |  |
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:
- Create an approval campaign as UserA and request approval.
- Log off from SAS Customer Intelligence Studio. Then, log on again as UserB and grant approval.
- Log off. Then, log on as UserA again.
- 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
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Customer Intelligence Reporting Mid-Tier | Microsoft® Windows® for x64 | 6.5 | 9.4 TS1M3 | ||
| 64-bit Enabled AIX | 6.5 | 9.4 TS1M3 | ||||
| 64-bit Enabled Solaris | 6.5 | 9.4 TS1M3 | ||||
| HP-UX IPF | 6.5 | 9.4 TS1M3 | ||||
| Linux for x64 | 6.5 | 9.4 TS1M3 | ||||
| Solaris for x64 | 6.5 | 9.4 TS1M3 | ||||
A fix for this issue for SAS Marketing Automation 6.6 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/H8P.html#66737| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-05-26 16:08:55 |
| Date Created: | 2020-10-08 11:17:36 |