Cannot use fields from CampaignMember:LeadOrContactOwner in Event Entry
Last updated 2021-01-28 ·Reference W-6587847 ·Reported By 8 users
When creating a Salesforce Data Event to target Campaigns, using fields from CampaignMember:LeadOrContactOwner causes exceptions when journey injection should happen.
-Create new journey
-Drag Salesforce Data Event onto canvas
-Select Salesforce Campaign
-Select a Campaign
-Select LeadOrContactOwner(User) City
-Click Next, Done
-Drag a random split onto the canvas
-Configure Journey Settings
-Go to Sales Cloud
-Click Marketing Cloud Tab
-Click Configure Marketing Cloud Connector
-Click Initiate Logs
-Add a lead or contact to the campaign above
-Go to Documents > Marketing Cloud logs, See the below error
*****2019-09-12 13:03:30.257|LOG STARTED
*****2019-09-12 13:03:30.257|PROCESS|Journey Builder Campaign Processor
*****2019-09-12 13:03:30.474|EXCEPTION|SObject row was retrieved via SOQL without querying the requested field: CampaignMember.City
Adding CampaignMember.City to the event data, or which ever field is thrown in the exception, should prevent the exception from occurring.
Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.