ETL not running
I have an ETL that's been running for over a year. I made some updates to it and now it will not run, despite the preview showing everything marked as green. The error message says "Saved but incomplete. Cannot be run until all actions are configured correctly."
Can anyone advise on what might be going on here? I've meticulously gone through every step and don't see any issues…
Answers
-
These are frustrating errors. When this has happened to me, if it says it saved, then I just close the tab and then run it from the ETL overview page. If it runs successfully, then I'm good. Otherwise, I go back in and edit again. Usually it runs fine after that.
Hope this helps.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
How do I get to the "ETL overview page"? Do you mean the overview page for the output dataset?
0 -
In the data center, click on the dataflows icon on the left side of the page.
then search for your dataflow name, "constructor ETL" and click on the title. This will take you to the Settings section of the dataflow. In the far right, you can click on the 3 dots and click on Run to force it to run.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
I don't see an option to run. Only view tags, create copy, or delete.
0 -
Looks like a permissions issue. Mine is like this:
I would reach out to your admin and get the permissions adjusted.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
After looking at this further, I do normally have the run option on ETLs (I am an admin), but for this one, I don't. And think the reason might be because it's still in draft mode… perhaps? If you look at my screenshot above, you'll notice it says "Draft" and I'm wondering if that is preventing me from running it from settings?
0 -
Possibly. Can you go back in and Edit the dataflow and then click Save and Run?
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
That's what I've been trying to no avail. When I click save and run (or just save), that's the message I get.
0 -
You'll likely need to reach out to Domo Support as it sounds like some back end wires are crossed with your ETL.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Seems like a support ticket might be necessary. In the meantime, you could copy and paste the contents of your ETL into a new ETL and try and run it. You will have to create new output datasets in the process. I would also suggest breaking it out into two ETLs and try and determine if it is the lower smaller workflow is the issue or the upper larger one.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
I opened this and I thought I was looking at a map of the game Risk.
John Le
You're only one dashboard away.
Click here for more video solutions:
2 -
@NathanDorsch It might also be worth copying the top and bottom flows from your screenshot into two separate test dataflows. If one runs successfully and the other doesn't that could help narrow down where the issue is. If they both run successfully, try reverting to a previous version of the original dataflow and re-do the updates you previously made if it's not too much of a lift.
0 -
I combined the second ETL into the top one. Still doesn't work.
I submitted a ticket and received this response: "I checked the ETL in question and there are 2 output datasets in the ETL with 2 different ETL processes. An ETL tile can only output one output dataset. To fix this issue, I suggest creating a separate ETL for the ETL at the bottom, please see screenshot, or joining the two output datasets into one dataset."
I run ETLs with multiple output datasets all the time. This is quite frustrating…
0 -
@NathanDorsch - is it because you are bringing in the same dataset multiple times?
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 299 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 730 Beast Mode
- 55 App Studio
- 40 Variables
- 682 Automate
- 175 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 10 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
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive