Failed While Executing

jacobpeterson
Domo Employee
in Archive
I recently attempted to push some additonal transforms to an existing mysql dataflow to incorporate some brand-new data points. When I went to run the dataflow, I received the error message below:
Failed while executing
The database reported a syntax error. Out of sort memory, consider increasing server sort buffer size
Has anyone else run into this issue? Solutions would be MOST appreciated.
P.s. I have already submitted a ticket to Domo Support addressing the issue.
0
Comments
-
I'm guessing you succesfully ran the transforms while in edit mode, and then this error came up?
Does the same error appear with subsequent attempts to manually run the dataflow?This message seems like an AWS system problem more than anything, not a configuration or syntax issue on your part.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Yup! The failure has persisted on both the regularly scheduled, automatic updates, as well as the manual pushes I have attempted.
0 -
Hm. I mean, if the transforms run in the edit mode but not in full runs, based on the message, maybe there's a data size issue. Are you running the proper indexes, too?
I hope Support has something to share. Let us know!
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive