cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mokhawaja
Level 8

Excute a SQL query bad gateway 504

Hi,

i started to see intermittent failed runs of my flows with this error:

 

{
  "error": {
    "code"504,
    "source""europe-001.azure-apim.net",
    "clientRequestId""fb18dfc3-dc5f-45dd-9684-8a2004bbf2b1",
    "message""BadGateway",
    "innerError": {
      "status"504,
      "message""A task was canceled.\r\nclientRequestId: fb18dfc3-dc5f-45dd-9684-8a2004bbf2b1",
      "source""sqlconnectionprovider-westeurope.am2-ase-001.p.azurewebsites.net"
    }
  }
}

here is the structure of my flow:

 

Screenshot (65).png

 

and here is the error inside my app:

 

 

Screenshot (66).png

 

i am not sure what's going on, please help!

 

thanks,

Mohammad

5 REPLIES 5
Anonymous
Not applicable

Re: Excute a SQL query bad gateway 504

I am having the same, intermitant, problem. Is there any resolution?

 

{
  "error": {
    "code"504,
    "source""europe-001.azure-apim.net",
    "clientRequestId""f7440808-3186-4888-a8ef-0b0af9302ffb",
    "message""BadGateway",
    "innerError": {
      "status"504,
      "message""A task was canceled.\r\nclientRequestId: f7440808-3186-4888-a8ef-0b0af9302ffb",
      "source""sqlconnectionprovider-westeurope.am2-ase-001.p.azurewebsites.net"
    }
  }
}

 

badgateway.JPG

Community Support Team
Community Support Team

Re: Excute a SQL query bad gateway 504

Hi @mokhawaja,

 

What is the connection in "Excute a SQL query" action connect to? Is it on line SQL Server or On-premise SQL Server?

 

If the connection in the "Excute a SQL query" action is with On-premise SQL Server is not supported in microsoft flow currently.

 

Best regards,

Alice

mokhawaja
Level 8

Re: Excute a SQL query bad gateway 504

it is Azure SQL

Zaahir
Level: Power Up

Re: Excute a SQL query bad gateway 504

Hi ,

 

Any updates on the error. We had the same 

SindAsh
Level: Powered On

Re: Excute a SQL query bad gateway 504

Please check out if you need to pass any parameters in the Stored Proc and Execute in server and check.

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (4,375)