Power Platform Community Forum Thread Details

Hi,

I have a very simple flow that is manually trigger to get data from a SQL Server database.

The connector began to fail yesterday when previous runs were good.

The connection was through an on-premise data gateway to a SQL server installed on the machine where the on-premise data gateway was installed.

I tried both Windows Authentication or SQL Login, but both gave intermittent success.

This is the flow. Both steps were using the same connector.

This is the flow run history. As you can see, there were some success and some failure.

In that 15 minutes, I did not change/edit the connector itself, nor any steps.

Why does the flow run sometimes and fails at others?

How to make sure the connector works?

Another thing I noticed about flow is that when I tried to add a link to an email step, I needed to add the link multiple times before the link can be added. It feels like I may have been doing things too fast that changes were not saved.

Any ideas?

Dan Chan

Categories:

Building flows

After working this for hours, I finally figured it out.

I installed another instance of the Microsoft On-Premise Data Gateway on a new machine in anticipation of migration things to the new machine. But, when I installed the new instance, I put it in the SAME cluster as the original one. I think here lies the problem.

The SQL Server I needed to connect to ONLY exists in the old machine.

So, I think when both gateways are put in the same cluster, when this gateway is used in PowerAutomate, either of the gateways can be used. I think the "new" gateway was called more often than the "old" one. Therefore, when the "new" gateway is used, the Flow fails. But, if the "old" gateway is used, the Flow succeed.

Thus, I uninstalled the "new" Gateway from the new machine. Resintalled it as a separate Gateway, not combined with another cluster.

Then, when I execute the Flow, the flow works!

Dan Chan