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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 738 Beast Mode
- 57 App Studio
- 40 Variables
- 685 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 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