Intermittent SFTP server connection issue within Azure logic app consumption

Shashank A Mishra 21 Reputation points
2024-06-03T13:47:14.1333333+00:00

Hi,
I have a Consumption logic app, in this logic app I have a scenario to read data from oracle table and create a file at destination SFTP server. This logic app runs every half an hour to pick up the latest data from oracle table and create a file at SFTP server.

This logic app fails randomly while creating file at SFTP server, error message mentioned below.

Below points are already verified:

  • Logic app IPs are already whitelisted at the SFTP server side.
  • I am using latest available SFTP-SSH connector for consumption logic app.
  • User id and password is correct and user id has all required permissions.
  • Data is not huge, only a single line within the file.

Please help me in understanding the root cause of the issue or why this problem generally occurs.

{

"error": {

"code": 502,

"source": "logic-apis-westeurope.azure-apim.net",

"clientRequestId": "xxxx-xxxx-xxxx-xxxx-xxxx",

"message": "BadGateway",

"innerError": {

  "status": 502,

  "message": "An established connection was aborted by the server.\r\nclientRequestId: xxxx-xxxx-xxxx-xxxx-xxxx",

  "error": {

    "message": "An established connection was aborted by the server."

  },

  "source": "sftpwithssh-we.azconn-we-002.p.azurewebsites.net"

}

}

}

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,222 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.