SUPPORT / SAMPLES & SAS NOTES
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:
PRINT(MACOMPUB): update CDM.CI_COMMUNICATION set deleted_flg = 'Y', processed_dttm="08FEB2019:12:14:35"dt where communication_sk in (selectcommunication_sk from DELETED_COMMUNICATION) ;
NOTE: The SQL statement cannot be executed directly against the database because it involves heterogeneous data sources.
NOTE: The SQL statement cannot be executed directly against the database because it involves heterogeneous data sources.
Summary Statistics for DB2 are:
Total row fetch seconds were: 1508.860074
Total SQL execution seconds were: 0.003221
Total row fetch seconds were: 1508.860074
Total SQL execution seconds were: 0.003221
NOTE: PROCEDURE SQL used (Total process time):
real time 25:21.41
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 | ||