Problem Note 64068: Performance issues occur when the SAS® Customer Intelligence common data model CI_COMMUNICATION table automatically updates
 |  |  |  |  |
In SAS® Marketing Automation, performance becomes slow after you delete Communication nodes from a campaign. When the nodes are deleted, the common data model CI_COMMUNICATION table is updated automatically. That is, the DELETED_FLG column in the table changes values from N to Y, and the updates occur. As records are added to the table over time, the update process takes more and more time.
When this problem occurs, an entry similar to the following is displayed in the SASCustIntelCore log:
NOTE: The SQL statement cannot be executed directly against the database because it involves heterogeneous data sources.
Total row fetch seconds were: 1508.860074
Total SQL execution seconds were: 0.003221
real time 25:21.41
To work around this problem, use an external process to delete records from the common data model tables that are marked with the DELETED_FLG=Y flag.
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 Marketing Automation | Microsoft® Windows® for x64 | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
| 64-bit Enabled AIX | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| 64-bit Enabled Solaris | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| HP-UX IPF | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Linux for x64 | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Solaris for x64 | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 | ||
A fix for this issue for SAS Marketing Automation 6.5 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Z77.html#64068| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-07-10 14:45:01 |
| Date Created: | 2019-04-19 15:35:51 |