Whoops! Something went wrong.

Yellow Belt

Whoops! Something went wrong.

I have a dataflow with 50+ transforms that has been working.  Recently I added some more transforms to it and now when I run the final transform that joins all the other transforms together I get this error in red "Invalid" next to the RUN SQL button.  Usualy if there is a syntax error or a missing transform it will tell you what the issue is and on what line.  I don't get a helpful error message. It just reads  "Whoops! Something went wrong." 


If I just run again "RUN SQL" some times it will finish with a green Valid message.  If I don't change anything and hit "RUN SQL" again it will fail with "Invalid" and "Whoops! Something went wrong.".  I can keep hitting RUN SQL over and over and its like flipping a coin on Invalid or Valid.   I tried commenting out the joins to the new transforms and this doesn't seem to make a difference.  It does seem to run valid more but it will still fail Invalid.  Time of day does seem to have an effect on this.  In the afternoon it will return Invalid more often than Valid.


Dataflow specs:

Data Input 1.7M rows / 1.39 GB 

Data Output is 436 rows / 1.26 MB


Is there a transform timeout limit that I'm running into? 

If so can this timeout limit be increased per dataflow or for my entire instance? 

Maybe my Domo instance needs to be migrated to a bigger AWS server with more processing power and faster disks?


**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'
Tags (1)
Blue Belt

Re: Whoops! Something went wrong.

"Whoops! Something went wrong." is often a system issue, I find.  It could be a hiccup in network or something on the Domo side.  Although, the fact that it also flips to "Invalid" is curious.  


This is a bit like asking if you've restarted your computer and cleared cache...but...

Have you gone through your transforms in order from top to bottom, running the SQL, and then hitting save and run at the end?  I have found that this sometimes helps to smooth out the SQL function.  If that works, just make sure to do that whenever you make changes to the query.  


If this doesn't work, perhaps some screenshots can help us figure it out.  

Breaking Down Silos - Building Bridges
Win free lodging at Domopalooza! We want to hear your Domo story, enter our Dojo contest and win up to four nights lodging at Domopalooza. Click here!