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.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive