SUPPORT / SAMPLES & SAS NOTES
Problem Note 30966: The multi-select node, or another node upstream from it, has failed to execute successfully when using the LIKE operator
 |  |  |  |  |
When using the LIKE operators in a SAS® Campaign Studio multi-select node on a character field with no metadata, your SAS® Marketing Automation might fail with the following error:
The MAIQService Execute Count Error generating physical Query Error Executing query, The multi-select node, or another node upstream from it has failed to execute successfully. error in services.log
For example if you include the line:
Postal Area LIKE A*
in a multi-select node and then feed that node into a node with a cell node, when you update counts in SAS Campaign Studio you will see this error.
Services.log will show something similar to:
YYYY-MM-DD HH:MM:SS,xxx [ERROR] ategies.sas.oma.relational.SQLGeneration - The object Type ="Filter", Label="", ID="xxxxxxxx" is not contained in the business model that created it.
Select 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 Campaign Studio | Microsoft® Windows® for x64 | 4.4 | 5.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows 2000 Advanced Server | 4.4 | 5.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Datacenter Server | 4.4 | 5.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Server | 4.4 | 5.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Professional | 4.4 | 5.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows NT Workstation | 4.4 | 5.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.4 | 5.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.4 | 5.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.4 | 5.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows XP Professional | 4.4 | 5.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Windows Vista | 4.4 | 5.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||