Cannot use the same Owner field twice in related object filter
Trailblazer Community

Cannot use the same Owner field twice in related object filter

Marketing Cloud Journey Builder

Last updated 2019-03-06 ·Reference W-5824967 ·Reported By 2 users

In Review

Summary
When creating a Salesforce Data Event, you are able to configure a related object filter criteria. If you use the Lead Object and select 2 of the same fields from Owner(user) in the related object filter, you will get the below on activation.

UNKNOWN_EXCEPTION;Owner_User_lookup (Record Query) - The field 'City' is being queried more than once in the same operation.;;Flow Save failed. Unable to activate the Journey, the Sales Cloud user may not have correct permissions. Activating a Journey requires the Run Flow and Manage Force.com Flow permissions.

Repro
-Create new journey from scratch
-Give it a name
-Drag the Salesforce Data Event onto the canvas
-Select the Lead Object > Lead ID > next
-Select Is Created > Next
-Select Owner(User) > City and drag it onto the canvas
-Do this a second time
-Configure both city filters
-Change the AND to an OR > Next > Next > Done
-Drag random split onto the canvas, configure it however
-Configure Journey Settings, Done
-Activate, note the error

UNKNOWN_EXCEPTION;Owner_User_lookup (Record Query) - The field 'City' is being queried more than once in the same operation.;;Flow Save failed. Unable to activate the Journey, the Sales Cloud user may not have correct permissions. Activating a Journey requires the Run Flow and Manage Force.com Flow permissions.

Workaround
Use the field only one time. If the field needs to be used more than once, try using it from a different related object lookup field such as CreatedBy.

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.