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.
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?
**Please mark the post that solves your problem as 'Accepted Solution'