Salesforce Quickstart Transformation Is Stuck in a Running Status

Issue

A Salesforce Quickstart transformation fails to complete. In Fivetran, the transformation displays a Running status indefinitely.

Environment

• Connector: Salesforce
• Transformation: Salesforce Quickstart

Resolution

To temporarily resolve this issue, do the following:

1. In Fivetran, go to the affected transformation page.
2. In the top right, pause the transformation by setting the Enabled toggle to OFF.
3. Select the Run log tab.
4. Identify the model(s) preventing your run from completing. The relevant models display a [RUN] status without a corresponding [SUCCESS] status. For example: 2 of 62 START sql view model [RUN]
5. Go to the associated Salesforce connection page.
6. In the top right, pause the connection by setting the ENABLED toggle to OFF.
7. Select the Schema tab.
8. Deselect the checkbox next to each object associated with the stuck model(s) from step 4.
9. Click Save changes.
10. Resume the connection by setting the ENABLED toggle to ON.
11. Go back to the transformation page and resume the transformation by setting the Paused toggle to ON.

To permanently prevent the same model(s) from impacting your transformation, consider adding a separate Salesforce connection for these objects and then applying a Quickstart transformation.

Cause

This issue occurs when a long-running transformation model included in the dbt run --select modelA modelB modelC command prevents other models from completing.