Salesforce Email Send Activity should be waiting until the step completes correctly before calling the next Step to continue
Trailblazer Community

Salesforce Email Send Activity should be waiting until the step completes correctly before calling the next Step to continue

Marketing Cloud Automations , Marketing Cloud Integrations

Last updated 2019-09-06 ·Reference W-5101096 ·Reported By 1 users

No Fix

Summary
In Automation Studio, If you defined Salesforce Email Send activity (1st step) and SQL activity (2nd step), which have the same Salesforce Data Extension(SF DE) as a target, are placed in a row, and SQL overwrites this SF DE on 2nd step, the SQL activity overrides the Target DE and send happens to new overridden DE.

This behavior just occurs when including Salesforce Email send activity and SQL activity. (this doesn't happen when using normal Email activity.)​

Repro
1) Import 5 Lead records to SF DE#1
2) Import 10 Lead records to SF DE#2
3) Create an Automation:
- STEP1: Salesforce Email Send (Email send to Lead in SF DE#1)
- STEP2: SQL activity (OverWrite from DE#2 to SF DE#1)
4) Run Once
5) Result:
- Expected result: Email sent is 5.
- Actual result: Email sent was 10.

Workaround
The workaround is to add one wait activity between steps. ​

Reported By (1)

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.