Resolve 'Retrieve treatment' query does not always work correctly in Portrait Interaction Optimizer
The quoted patch is only to be applied to version 5.5 of an existing implementations of Interaction Optimizer.
Issue
In Interaction Optimizer (IO) v5.5, the details of an Offer associated with a Marketing Activity are missing from recent IO treatment history.
Specifically, treatments that have been made since the last refresh of the Portrait Data Warehouse appear to have missing Offer details.
The Data Warehouse is typically scheduled to refresh at least every hour.
Specifically, treatments that have been made since the last refresh of the Portrait Data Warehouse appear to have missing Offer details.
The Data Warehouse is typically scheduled to refresh at least every hour.
Cause
The 'GetTreatmentHistory' procedure and related IO Data Access Transaction does not retrieve the same columns for 'Offer' from the Data Warehouse as we do from IO treatment staging table.
Resolution
UPDATED: April 21, 2017Apply Patch TFS-30414 which is available for download from the Portrait Support ftp site.
Alternatively, contact Portrait Support via email and request the patch.
Alternatively, contact Portrait Support via email and request the patch.
