Excute a SQL query bad gateway 504

[mokhawaja]

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:

and here is the error inside my app:

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

thanks,

Mohammad

[Anonymous]

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"
    }
  }
}

[v-yuazh-msft]

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]

it is Azure SQL

[Zaahir]

Hi ,

Any updates on the error. We had the same 

[SindAsh]

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