Problem Note 42263: A SAS® Marketing Optimization group might return the error "Missing column detected in Historic_communications table" and fail to run
The SAS Marketing Optimization group fails to run with the following error if you are using contact history and mandatory inclusions together:
Missing column detected in Historic_communications table
This problem occurs only when you create contact policies that have communication filters using the MANDATORY, EXCLUDE_FROM_CONSTRAINTS, or EXCLUDE_FROM_CONTACT_POLS columns. Most contact policy filters are on channel or campaign code.
The workaround is to either use either contact history or mandatory inclusions, but not both.
Operating System and Release Information
| SAS System | SAS Marketing Optimization | Microsoft® Windows® for x64 | 5.4 | 6.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| 64-bit Enabled AIX | 5.4 | 6.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| 64-bit Enabled HP-UX | 5.4 | 6.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| 64-bit Enabled Solaris | 5.4 | 6.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| HP-UX IPF | 5.4 | 6.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Linux for x64 | 5.4 | 6.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Solaris for x64 | 5.4 | 6.1 | 9.2 TS2M3 | 9.3 TS1M0 |
*
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: | medium |
| Date Modified: | 2012-01-11 09:36:17 |
| Date Created: | 2011-02-02 12:25:28 |
