Problem Note 45469: SAS® Marketing Optimization takes a very long time or does not finish at all when adding constraints or refreshing data
 |  |  |  |  |
When you add constraints or refresh data, SAS Marketing Optimization might take a very long time or fail to complete execution of these tasks. When this slow-down happens, the SAS Marketing Optimization client session that is associated with the tasks appears unresponsive. There are no errors or warnings reported in the log files when the problem occurs. Instead, it appears that the logs have stopped updating.
One reason that this problem occurs is that SAS Marketing Optimization performs PROC SQL statements to retrieve column names in the SAS dictionary tables. These queries result in a traversal of all librefs that are defined in your repository. This traversal might take a very long time if your environment has a large number of libraries and/or a large number of tables in those libraries.
Another underlying cause for the behavior described above is that the software might reach the maximum number of connections to the database(s) underlying those librefs.
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 Optimization | Microsoft® Windows® for x64 | 5.4 | 6.1 | 9.3 TS1M2 | |
| 64-bit Enabled AIX | 5.4 | 6.1 | 9.3 TS1M2 | |||
| 64-bit Enabled HP-UX | 5.4 | 6.1 | 9.3 TS1M2 | |||
| 64-bit Enabled Solaris | 5.4 | 6.1 | 9.3 TS1M2 | |||
| HP-UX IPF | 5.4 | 6.1 | 9.3 TS1M2 | |||
| Linux for x64 | 5.4 | 6.1 | 9.3 TS1M2 | |||
| Solaris for x64 | 5.4 | 6.1 | 9.3 TS1M2 | |||