Problem Note 49043: Performance problems occur when you use SAS® Marketing Automation integrated with SAS® Marketing Optimization
 |  |  |  |  |
Executing more than 90 communications in SAS Marketing Automation, where the output is used as input for SAS Marketing Optimization, can result in long run times (between 4 and 5 hours for approximately 20 million customers).
The problem occurs with the maexport process because it is limiting the CUSTOMER table, which is used by SAS Marketing Optimization, to 1.114 variables.
The time that SAS Marketing Automation takes to create the moma_input tables is the longest process. It can take approximately 2 hours to generate.
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 | 5.4 | 6.3 | 9.4 TS1M1 | |
| Microsoft Windows 8 Pro | 5.4 | 6.3 | 9.4 TS1M1 | |||
| Microsoft Windows Server 2008 | 5.4 | 6.3 | 9.4 TS1M1 | |||
| Microsoft Windows Server 2008 for x64 | 5.4 | 6.3 | 9.4 TS1M1 | |||
| Microsoft Windows Server 2012 | 5.4 | 6.3 | 9.4 TS1M1 | |||
| Windows 7 Enterprise 32 bit | 5.4 | 6.3 | 9.4 TS1M1 | |||
| Windows 7 Enterprise x64 | 5.4 | 6.3 | 9.4 TS1M1 | |||
| Windows 7 Home Premium 32 bit | 5.4 | 6.3 | 9.4 TS1M1 | |||
| Windows 7 Home Premium x64 | 5.4 | 6.3 | 9.4 TS1M1 | |||
| Windows 7 Professional 32 bit | 5.4 | 6.3 | 9.4 TS1M1 | |||
| Windows 7 Professional x64 | 5.4 | 6.3 | 9.4 TS1M1 | |||
| Windows 7 Ultimate 32 bit | 5.4 | 6.3 | 9.4 TS1M1 | |||
| Windows 7 Ultimate x64 | 5.4 | 6.3 | 9.4 TS1M1 | |||
| 64-bit Enabled AIX | 5.4 | 6.3 | 9.4 TS1M1 | |||
| 64-bit Enabled HP-UX | 5.4 | 6.3 | 9.4 TS1M1 | |||
| 64-bit Enabled Solaris | 5.4 | 6.3 | 9.4 TS1M1 | |||
| HP-UX IPF | 5.4 | 6.3 | 9.4 TS1M1 | |||
| Linux | 5.4 | 6.3 | 9.4 TS1M1 | |||
A fix for this issue for SAS Marketing Automation 5.4_M1 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/E08.html#49043A fix for this issue for SAS Marketing Automation 5.41 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/E88.html#49043| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2013-02-01 13:45:31 |
| Date Created: | 2013-01-31 16:41:40 |