Problem Note 59734: Refreshing SAS® Marketing Optimization input data in a campaign group fails when the underlying database is Microsoft SQL
 |  |  |  |  |
In SAS Marketing Optimization, refreshing input data in a campaign group might fail in the step Execute tasks for generation of optimization input data when the underlying database is Microsoft SQL.
When this problem occurs, you might encounter the following error in the SASCustIntelCore6.5.log file:
ERROR: CLI open cursor error: [SAS][ODBC SQL Server Driver]Connection is busy with results for another hstmt
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
MPRINT(MAMOCH): quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
MPRINT(MAMOCH): quit;
NOTE: The SAS System stopped processing this step because of errors.
Note: This error happens only when you use treatment optimization with the Contact History enabled and where the Contact History tables are not empty. If the Contact History tables are empty, the optimization data is created successfully.
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 | 6.5 | |||
A fix for this issue for SAS Marketing Automation 6.5 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Z77.html#59734| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2017-03-02 08:57:34 |
| Date Created: | 2017-01-18 11:33:33 |