SFTP SSH Connection from Logic App Errors

Question

SFTP SSH Connection from Logic App Errors

Anonymous

hi There

We are trying to set up a SFTP connection from our logic app (consumption), and it request fails with below error -

We tried monitoring the incoming requests at the SFTP server end but unable to see any request coming through. What should we be looking at?

User's image

 "innerError": {
                "status": 504,
                "message": "A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond\r\nclientRequestId: 7b8cc767-d694-4901-bc99-1315f63a1faf",
                "error": {
                    "message": "A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond"
                },

MayankBargali-MSFT 70,936 Reputation points Moderator

2023-02-10T06:12:56.3166667+00:00
@Mahandru, Nidhi Thanks for reaching out. As per the error shared it looks like the Logic App was unable to establish a connection to the SFTP server. This can be caused by a number of factors, such as incorrect connection information, network issues, or firewall restrictions.

To troubleshoot this issue, you can try the following steps:

Verify that the connection information, such as the server address, username, and password, is correct.

Check if there are any network issues or firewall restrictions that are preventing the Logic App from connecting to the SFTP server.

Check if the SFTP server is running and accessible.

Check if the SFTP server is configured to allow connections from the Logic App's IP address.

Check if the SFTP server is configured to use the correct SSH key.

Check if the SFTP server is configured to use the correct SSH key password.

You can also refer to the documentation link provided in the conversation for more details on troubleshooting SFTP-SSH connections in Logic Apps.

To troubleshoot Azure SFTP SSH: SFTP - SSH - Connectors | Microsoft Learn

To troubleshoot build in SFTP SSH: SFTP - Connectors | Microsoft Learn
Anonymous

2023-02-10T09:36:45.0033333+00:00

hi @MayankBargali-MSFT Please see my answers below

1 is correct we have tested the credentials via WinSCP.

2 We cant seem to find logs on what IP the logic app is going out with. Could you help us locate them?

3 SFTP Server is working.

4 We have allowed this

5 & 6 we are not using at the moment
Anonymous

2023-02-10T09:58:32.1533333+00:00

@MayankBargali-MSFT For some reason I am unable to see your last comment here on Microsoft portal, but I read few lines from the email that I received.
So we are using SFTP-SSH (Azure) connector in our standard logic app.
I read somewhere that managed connector have their own IP. If that is the case, how do I find out what IP this connector have? Do we need to whitelist that as well?
Also, the current SFTP portal we are trying to connect to has no firewall. the connection is failing even for that.
MayankBargali-MSFT 70,936 Reputation points Moderator

2023-02-10T10:00:11.3+00:00

@Mahandru, Nidhi Please refresh the page or open in private windows and you should be able to see the details as it could be browser/network issue.
Anonymous

2023-02-14T06:43:06.4933333+00:00
hi @MayankBargali-MSFT I tried using the built in SFTP connector, and get this error now. The SFTP server I am trying to connect to has no firewall and it allows traffic from all public networks. We can connect to the SFTP network using WinSCP with same credentials that we have used while connecting via Azure Logic App. If we see the server logs, we cannot see this request even reaching the SFTP server. We are puzzled what is wrong

{ "statusCode": "GatewayTimeout", "body": { "code": "ServiceProviderActionFailed", "message": "The service provider action failed with error code 'GatewayTimeout' and error message 'An existing connection was forcibly closed by the remote host.'." } }
Anonymous

2023-02-14T06:43:16.0366667+00:00

@MayankBargali-MSFT hi Mayank, Are you able to join a call with us for 30 mins or so? It would make things quicker at our end. Please let me know what you think.
MayankBargali-MSFT 70,936 Reputation points Moderator

2023-02-14T06:44:51.2033333+00:00

@Mahandru, Nidhi Sure we can connect offline. Please send please send an email with subject line “Attn:Mayank” to AzCommunity[at]Microsoft[dot]com referencing this thread along with your availability in UTC so I can schedule the call to assist you further.
MayankBargali-MSFT 70,936 Reputation points Moderator

2023-02-28T04:27:04.16+00:00

Hi @Anonymous

I hope the answer and comment cleats things up. Feel free to get back to me if you need any assistance.

Please accept as "Yes" if the answer is helpful so that it can help others in the community. If you need any help/clarification/concerns/follow up questions, then please click on "Add Comment" on my answer and provide more details.
Anonymous

2024-09-23T10:51:43.1966667+00:00

We are using standard logic app behind the firewall and we have whitelisted that firewall static ip at sftp server end still we are not able to reach to sftp server from standard logic app, do we need to enable NAT gateway on the vnet that logic app is connected with ?

Accepted answer

0 additional answers

Your answer

MayankBargali-MSFT 70,936 Reputation points Moderator

2023-02-10T06:12:56.3166667+00:00

@Mahandru, Nidhi Thanks for reaching out. As per the error shared it looks like the Logic App was unable to establish a connection to the SFTP server. This can be caused by a number of factors, such as incorrect connection information, network issues, or firewall restrictions.

To troubleshoot this issue, you can try the following steps:

Verify that the connection information, such as the server address, username, and password, is correct.

Check if there are any network issues or firewall restrictions that are preventing the Logic App from connecting to the SFTP server.

Check if the SFTP server is running and accessible.

Check if the SFTP server is configured to allow connections from the Logic App's IP address.

Check if the SFTP server is configured to use the correct SSH key.

Check if the SFTP server is configured to use the correct SSH key password.

You can also refer to the documentation link provided in the conversation for more details on troubleshooting SFTP-SSH connections in Logic Apps.

To troubleshoot Azure SFTP SSH: SFTP - SSH - Connectors | Microsoft Learn

To troubleshoot build in SFTP SSH: SFTP - Connectors | Microsoft Learn
Anonymous

2023-02-10T09:36:45.0033333+00:00

hi @MayankBargali-MSFT Please see my answers below

1 is correct we have tested the credentials via WinSCP.

2 We cant seem to find logs on what IP the logic app is going out with. Could you help us locate them?

3 SFTP Server is working.

4 We have allowed this

5 & 6 we are not using at the moment
Anonymous

2023-02-10T09:58:32.1533333+00:00

@MayankBargali-MSFT For some reason I am unable to see your last comment here on Microsoft portal, but I read few lines from the email that I received.
So we are using SFTP-SSH (Azure) connector in our standard logic app.
I read somewhere that managed connector have their own IP. If that is the case, how do I find out what IP this connector have? Do we need to whitelist that as well?
Also, the current SFTP portal we are trying to connect to has no firewall. the connection is failing even for that.
MayankBargali-MSFT 70,936 Reputation points Moderator

2023-02-10T10:00:11.3+00:00

@Mahandru, Nidhi Please refresh the page or open in private windows and you should be able to see the details as it could be browser/network issue.
Anonymous

2023-02-14T06:43:06.4933333+00:00

hi @MayankBargali-MSFT I tried using the built in SFTP connector, and get this error now. The SFTP server I am trying to connect to has no firewall and it allows traffic from all public networks. We can connect to the SFTP network using WinSCP with same credentials that we have used while connecting via Azure Logic App. If we see the server logs, we cannot see this request even reaching the SFTP server. We are puzzled what is wrong

{ "statusCode": "GatewayTimeout", "body": { "code": "ServiceProviderActionFailed", "message": "The service provider action failed with error code 'GatewayTimeout' and error message 'An existing connection was forcibly closed by the remote host.'." } }
Anonymous

2023-02-14T06:43:16.0366667+00:00

@MayankBargali-MSFT hi Mayank, Are you able to join a call with us for 30 mins or so? It would make things quicker at our end. Please let me know what you think.
MayankBargali-MSFT 70,936 Reputation points Moderator

2023-02-14T06:44:51.2033333+00:00

@Mahandru, Nidhi Sure we can connect offline. Please send please send an email with subject line “Attn:Mayank” to AzCommunity[at]Microsoft[dot]com referencing this thread along with your availability in UTC so I can schedule the call to assist you further.
MayankBargali-MSFT 70,936 Reputation points Moderator

2023-02-28T04:27:04.16+00:00

Hi @Anonymous

I hope the answer and comment cleats things up. Feel free to get back to me if you need any assistance.

Please accept as "Yes" if the answer is helpful so that it can help others in the community. If you need any help/clarification/concerns/follow up questions, then please click on "Add Comment" on my answer and provide more details.
Anonymous

2024-09-23T10:51:43.1966667+00:00

We are using standard logic app behind the firewall and we have whitelisted that firewall static ip at sftp server end still we are not able to reach to sftp server from standard logic app, do we need to enable NAT gateway on the vnet that logic app is connected with ?

Answer 1

MayankBargali-MSFT 70,936 Moderator

@Mahandru, Nidhi Can you please confirm if you are using Azure SFTP SSH connector or built in SFTP SSH connector as the IP address will change. If you are using the Azure SFTP SSH connector, then the communication will be your workflow --> SFTP connector --> Your SFTP server so in this case you need to whitelist the IP address as per the regions listed here at your SFTP server end. In case if you are using the Build in SFTP connector then the communication will be logic app --> your sftp server so you need to whitelist the outbound IP address of your standard logic app. To find the outbound IP address you can refer to this document.

Please confirm if you have whitelisted the right IP address as per your Azure or built-in connectors. For more details on connector categories please refer to this document.

Anonymous

2023-02-22T17:52:26.2566667+00:00

hi @MayankBargali-MSFT That solution worked. We are now able to connect to 3rd Party SFTP portal using Built-in SFTP connector.

However, I noticed there is no action to 'Create File' using this connector in Standard Logic App unlike Consumption based where there is 'Create File' action available.
Any pointers how we can create file at 3rd Party SFTP portal using Built in SFTP connector.
For your reference, my current file reside in blob at my end. so my flow is -
List Blob - Get Blob Content - ?

I tried using sftp - upload file content after this but it does not seem to work.

Thanks in advance
MayankBargali-MSFT 70,936 Reputation points Moderator

2023-02-23T07:53:40.7033333+00:00

@Anonymous Thanks for the confirmation. Glad to know that the initial issue is resolved.

To create the file, you should use the "Upload file Content" action. When you mentioned that you have leverage this action "but it does not seem to work then" then are you getting any error/exception in the run history for this action or did it create the empty file for you. In case if this is empty file then please make sure that you are passing the file content correctly and the File Content is base 64 string?

In case if you still facing the issue then please create a new QnA post so we can track this new issue and this will also help community members facing the similar type of issue.

Feel free to accept as "Yes" so that it can help others in the community facing the similar issue and tag me in new QnA post in case if you still observe the issue.
Anonymous

2023-02-23T08:54:32.6933333+00:00

hi @MayankBargali-MSFT this option seems to work if I put an empty file at destination, then upload file content action seems to copy the content into that file.
is there no option to create file from scratch?

If I dont have file in destination already, it gives me error the path does not exist.
MayankBargali-MSFT 70,936 Reputation points Moderator

2023-02-23T09:07:19.2233333+00:00

@Anonymous Can you share the screenshot. You should pass the filename, so it creates the file for you along with the extension and then pass the file content. In case if you are passing the path then make sure you are also passing the filename and extension.
Anonymous

2023-02-28T13:00:46.67+00:00
@MayankBargali-MSFT - Thanks for all the help. Upload file content task does work. One last issue that it still cannot cope with is if there are more than 1 file for it to transfer. It is inside a foreach loop and it does run fine for the first iteration, but on 2nd one it fails with the error

I have pasted below the pictures

{"statusCode":"NotFound","body":{"code":"ServiceProviderActionFailed","message":"The service provider action failed with error code 'ServiceOperationInvalidParameter' and error message 'The file or folder path '/Order Routing/Staging/TestFile.tmp' isn't valid or doesn't exist.'."}}
MayankBargali-MSFT 70,936 Reputation points Moderator

2023-03-02T07:43:13.88+00:00

@Anonymous Are you using any dependency of some variable inside the loop for your Upload File action. Can you try running your loop in the sequential i.e. enabled the Concurrency Control and set the Degree of Parallelism to 1 on your loop settings in case if there is any dependency on the parameter that you are using in your action and see if it helps you. Please share the workflow screenshot and values that you are specifying in your action in case if you still observe the issue.

Share via

SFTP SSH Connection from Logic App Errors

0 additional answers

Your answer