Error: An error occurred before executing the process 'Invitation Process' : An error occurred before executing the process 'Marketing Effort Activate Process' - when running an event invitation process

When running an event invitation process with a selection in the output, users receive the error: 

An error occurred before executing the process 'Invitation Process' :
An error occurred before executing the process 'Marketing Effort Activate Process' :
Error activating the marketing effort:
Error running marketing effort export.
An error occurred before executing the process 'Marketing Effort Export Process' :
Error running marketing effort export. Invalid column name '[query selection name]'.
Download and install the latest patch, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch. 

Alternative Solution:
  1. When running the Invitation process, mark the checkbox to Create a selection.
  2. In Analysis, Query, create a new constituent ad-hoc query.
  3. Expand Selections, add Exists in [event invitation selection] equal to Yes. 
  4. In Selections, drag and drop Exists in [selection used in the export definition output] to the Results fields to display.

Environment

 2.91.1535.94
 2.93.2034, patch 58 ; 2.94.1524, patch 39 ; 2.91.1535, patch 97

Was this article helpful?