Forum Discussion
Super UserSporadic Gateway Error (Mashup error) Dataflow
Super UserThe source Is a SQL server, the gateway Is on the same machine of the SQL server.Wait what?!?! Why?!?
There's no latency but there will be a bitter fight for resources. Don't do that.
Super UserWhy? What's wrong? I usually build this setup with no issue. I do the etl during night hours.
What should I do instead?
- lbendlin
Gateway VMs need to be dedicated to just the gateway service. It is designed to consume all the CPU and all the memory on that VM. As well as all the network for DQ.
You are supposed to have multiple VMs per gateway anyway.
- Gabry
I'm looking further into your suggestions and I keep investigating the issue, in the meantime, I noticed that I can set up a Power Automate flow to rerun the dataflow in case of failure, so I set this up, and it's working great.
- lbendlin
I noticed that I can set up a Power Automate flow to rerun the dataflow in case of failure,That's not what you want to do. First understand the reason for the failure then decide if you need to fix that or if a retry is appropriate.