Hello - I am wondering on whether anyone here can provide some pointers on how to best troubleshoot the Blackbaud SFTP Connector used as part of the Power Automate Flow. My work currently utilizes Power Automate and the SFTP connector to transfer data into Microsoft Shared List for reporting. When the flow fails, it points to a bad gateway error:
The Input and Output error messages are:
Output
{
"host": {
"connectionReferenceName": "shared_sftpwithssh_1",
"operationId": "GetFileContentByPath"
},
"parameters": {
"path": "/C:/FTPHome/2bce8953-9d72-4079-8b1b-a841395998ab$/FTP/Queue Exports FTP/Files to OneDrive/Gifts - v1.CSV",
"inferContentType": true
}
}
Input
{
"statusCode": 502,
"headers": {
"Pragma": "no-cache",
"Cache-Control": "no-store, no-cache",
"Set-Cookie": "ARRAffinity=ce13854895b3c07570ec5b297a0755efcce04ad9a9d04c7a01caef545276de64;Path=/;HttpOnly;Secure;Domain=sftpwithssh-scus.azconn-scus-001.p.azurewebsites.net,ARRAffinitySameSite=ce13854895b3c07570ec5b297a0755efcce04ad9a9d04c7a01caef545276de64;Path=/;HttpOnly;SameSite=None;Secure;Domain=sftpwithssh-scus.azconn-scus-001.p.azurewebsites.net",
"x-ms-datasourceerror": "True",
"x-ms-request-id": "887ed567-7198-459a-9652-076e17078b23",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"X-Content-Type-Options": "nosniff",
"X-Frame-Options": "DENY",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "true",
"x-ms-apihub-obo": "false",
"Date": "Thu, 20 Oct 2022 12:52:17 GMT",
"Content-Length": "575",
"Content-Type": "application/json",
"Expires": "-1"
},
"body": {
"error": {
"code": 502,
"source": "flow-apim-msmanaged-na-eastus-01.azure-apim.net",
"clientRequestId": "887ed567-7198-459a-9652-076e17078b23",
"message": "BadGateway",
"innerError": {
"status": 502,
"message": "An existing connection was forcibly closed by the remote host\\r\\nclientRequestId: 887ed567-7198-459a-9652-076e17078b23",
"error": {
"message": "An existing connection was forcibly closed by the remote host"
},
"source": "sftpwithssh-scus.azconn-scus-001.p.azurewebsites.net"
When I log into the Power Automate website to look at the flow itself, it'll show a Blackbaud SFTP connector invalid error:
When I see a failed flow message, I would check connection with FileZilla, and it appears that while FileZilla can connect successfully, the flow itself would fail and show bad gateway and invalid BB SFTP connector. I am wondering on how to get proper support or troubleshoot. Anything is appreciated. Thank you.
