What are the best steps to troubleshoot a dataflow that has stopped?
Comments
-
When I'm troubleshooting a dataflow, my first step is to go to the details page for the dataflow. To get there, go to the Data Center and click the wrench menu for the dataflow you want to troubleshoot. Choose the "Details" option.
From the details page, you can see the history of the attempted runs of the dataflow. If it has failed you'll see the Start Time, End Time, Duration, and then "Failed" as the Status. If you hover over the Failed message, the error message that was logged when it failed. Most of the time, this is an error that came back directly from the database and can seem fairly intimidating. In that error, though, there's generally information to glean about what went wrong (missing column, incompatible data types, etc.). If it isn't clear from the error message alone, click on the "Failed" message and you'll see each transform in the dataflow with a green or red box around it. The green ones succeeded and the red one failed. Hopefully with the combination of the error message and the transform that failed, you can track down the error.
As a note, it has been my experience that if a dataflow was working and then suddenly stopped, it very frequently comes down to having a change in the schema of one of the input datasets. It can stop unions for working if the number or types of the columns changes. It call also break transforms if fields disappear that were being used in the transform.
I hope these ideas help!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 99 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 727 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive