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
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 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2013-02-01 13:45:31 |
Date Created: | 2013-01-31 16:41:40 |