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
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"
}
}
}
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
it is Azure SQL
Hi ,
Any updates on the error. We had the same
Please check out if you need to pass any parameters in the Stored Proc and Execute in server and check.
User | Count |
---|---|
22 | |
15 | |
14 | |
10 | |
9 |
User | Count |
---|---|
45 | |
29 | |
25 | |
24 | |
24 |