Problem Note 43352: An error occurs when you run a scenario in SAS® Marketing Optimization
 |  |  |  |  |
A scenario optimization job in SAS Marketing Optimization fails, and the optimize.log file shows the following error:
MO START TIME: 15:09:28
WARNING: Apparent symbolic reference NEWCUSTCOMMCOLUMN10000 not resolved.
84 &newCustCommColumn10000
_
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
When each calculated measure is created in SAS Marketing Optimization, a new column is automatically created in the (temporary) customer table for every communication. Assuming that you have a large number of communications, the number of columns might exceed the predefined limit of 9,999. For example, if you have 1,080 communications and you have 10 calculated measures, 1,080 new columns per measure have to be added. The problem occurs when the number of such columns is greater than 9,999.
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 | 5.41 | 9.2 TS2M3 | 9.3 TS1M1 |
| 64-bit Enabled AIX | 5.4 | 5.41 | 9.2 TS2M3 | 9.3 TS1M1 | ||
| 64-bit Enabled HP-UX | 5.4 | 5.41 | 9.2 TS2M3 | 9.3 TS1M1 | ||
| 64-bit Enabled Solaris | 5.4 | 5.41 | 9.2 TS2M3 | 9.3 TS1M1 | ||
| HP-UX IPF | 5.4 | 5.41 | 9.2 TS2M3 | 9.3 TS1M1 | ||
| Linux for x64 | 5.4 | 5.41 | 9.2 TS2M3 | 9.3 TS1M1 | ||
| Solaris for x64 | 5.4 | 5.41 | 9.2 TS2M3 | 9.3 TS1M1 | ||
A fix for this issue for SAS Marketing Optimization 5.4_M1 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/E10.html#43352| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2011-08-26 09:10:19 |
| Date Created: | 2011-05-25 14:41:19 |