Workbench Job Hanging, Dataset stuck on 'Preparing'
I have a scheduled Workbench job to update a dataset that typically takes 30ish mins to run. The job started yesterday at 1:37pm and has been stuck on 'Preparing..' in the Result field (on the History tab) since then. I just canceled the workbench job and started a new manual run. It started a new run, but the history tab still shows the previous run as 'Preparing...'. Here is what I'm seeing:
I'm still waiting to see if the manual run will be successful, but any ideas on what might be happening? Could it be related to the size of the dataset?
-------- UPDATE ---------
The manual run was successful, and the row with 'Preparing...' went away. So I guess the issue is resolved, but it would still be nice to know if anyone could shed light on the situation, though I imagine there are a number of possible causes.
Answers
-
@walker_page Domo support would be the best person to direct that question to as they do have access to error logs.
that said, it looks like you're pushing 9.3M rows of data with each push. Is that a full replace or an APPEND? if it's a replace, can you adopt an incremental load strategy?
https://dojo.domo.com/discussion/2790/appending-data-capture-using-domo-workbench
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 691 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 112 Manage
- 109 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive