cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rmcleod45
Frequent Visitor

Connections disappearing in flow but still in connection list

Hello, I have encountered this error a couple of times now with different connections. 

 

I have  a flow that was running all night and then started to fail this morning. It is a connection to a On-Prem SQL database through a data gateway.

 

The flows have failed wtih this error:FlowFailed.PNG

 

Unable to process template language expressions in action 'Get_rows' inputs at line '1' and column '1980': 'The template language expression 'json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$connections']['shared_sql']['connectionId']' cannot be evaluated because property 'shared_sql' doesn't exist, available properties are 'shared_sharepointonline, shared_onedriveforbusiness'. Please see https://aka.ms/logicexpressions for usage details.'.

 

 

 

My list of connections still shows the SQL connection and the connection is workingConnectionExists.PNG

 

I have another test flow with the same connection and it works just fine. 
ConnectionWorking.PNG

I am not sure why this is happening but it has happened a few times now, once with an approval workflow. I have recreated a number of flows to get around this but that is extremely frustrating.

 

Any help would be greatly appreciated.

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Brad_Groux
Community Champion
Community Champion

This is almost certainly a communication issues with the on-premise data gateway. Please review the Troubleshooting the On-premises data gateway documentation, and also review the Port requirements and the Firewall and proxy documentation and insure that your proxy or firewall allows access over those ports. 

Please review both hardware and software firewalls, including the Windows Firewall on the server. Finally, the Tools for troubleshooting section covers collecting logs and Fiddler tracing

For one reason or another, as the Flow is running, it can't communicate with the connections setup through the gateway. I'd check the sytem logs of the server or PC where you are running the connector, and see if you can correlate a drop in network activity to the times when the Flows failed. 

Also, insure that all of the required ports for the connector are always in use and not blocked or filtered by a proxy or firewall. If you'll notice the data gateway port requirements are far more than port 80 and 443:

*.servicebus.windows.net        5671-5672	  Used for Advanced Message Queuing Protocol (AMQP).	
*.servicebus.windows.net	443, 9350-9354	  Used by listeners on Service Bus Relay over TCP (requires 443 for access control token acquisition).

For most firewalls, port 80 and 443 are open because they are the HTTP/S ports, however the ports listed above would not be open by default.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

4 REPLIES 4
Brad_Groux
Community Champion
Community Champion

This is almost certainly a communication issues with the on-premise data gateway. Please review the Troubleshooting the On-premises data gateway documentation, and also review the Port requirements and the Firewall and proxy documentation and insure that your proxy or firewall allows access over those ports. 

Please review both hardware and software firewalls, including the Windows Firewall on the server. Finally, the Tools for troubleshooting section covers collecting logs and Fiddler tracing

For one reason or another, as the Flow is running, it can't communicate with the connections setup through the gateway. I'd check the sytem logs of the server or PC where you are running the connector, and see if you can correlate a drop in network activity to the times when the Flows failed. 

Also, insure that all of the required ports for the connector are always in use and not blocked or filtered by a proxy or firewall. If you'll notice the data gateway port requirements are far more than port 80 and 443:

*.servicebus.windows.net        5671-5672	  Used for Advanced Message Queuing Protocol (AMQP).	
*.servicebus.windows.net	443, 9350-9354	  Used by listeners on Service Bus Relay over TCP (requires 443 for access control token acquisition).

For most firewalls, port 80 and 443 are open because they are the HTTP/S ports, however the ports listed above would not be open by default.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

v-yamao-msft
Community Support
Community Support

Hi @rmcleod45 ,

 

Do you have any functions in the action Get rows?

 

Please make sure SQL Server is always running.

 

If possible, please try to resubmit the flow to see if the run will succeed.

 

Further, please make sure there are no modifications on the table fields.

 

When testing with action Get rows, it is working properly.

1.PNG

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-yamao-msft
Community Support
Community Support

Hi @rmcleod45 ,

 

What’s your current situation?

If the issue still exists, please feel free post back.

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I am still working with our IT team to ensure that our gateway is configured correctly. I haven't had the same issue since, I ended up redesigning the flow anyways. 

 

Thank you for your resonse and sorry for not replying earlier. Wanted to wait to see what our IT came back with.

 

I will accept this as a solution.

 

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Users online (4,046)