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
- 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.8K Visualize
- 2.5K Charting
- 738 Beast Mode
- 56 App Studio
- 40 Variables
- 684 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 35 Predict
- 14 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 123 Manage
- 120 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