SFTP Smart Services

Hi Ivan Garcia,

Sorry for the delay. We were analysing this issue but in between we got stuck with other priority work items. We will look into this issue once we complete them and we will reply you by early next week

Hi,

Did you manage to reproduce the error? Any updates?

Hi,

We are getting that error when trying to upload files with size of 8kb or more to an external SFTP server. Other uploading methods against that server (for example, via sftp utilities or cmd) work fine. Sent attached an example of a file that shows the problem when uploading through the plugin, but with the command line tool it is uploaded succesfully.

exceltest.xlsx

Hi,
Please share us with the steps to reproduce the issue because we cannot reproduce the issue from our side. Thanks.

Good morning,

Any updates about this? We need to deploy this functionality as soon as possible and this is blocking the deployment. Thank you.

Hi Iván García, 

We will analyse the issue and get back to you.

Hi,

We are getting an unexpected error when using the Send File Over SFTP smart service (using a private key). We have a requirement to send some files to an external SFTP server and for some of them it works fine and almost instantly (small files), but when using bigger files (the file size can vary from some KB to even MB in some cases) the node will take way more time to complete (some minutes, regardless of the file size) and report the FAILED flag with the following error: "java.io.IOException: inputstream is closed". This is not something that happens randomly, it always fails for those files. The external SFTP server is not managed by us, but their IT team told us logs show that the connection is being closed abruptly.

 This issue only happens with this smart service, the rest of them works fine against that server.

Log trace:

2022-04-27 14:47:42 INFO [Appian Work Item - 510542 - execution01 : UnattendedJavaActivityRequest] com.appiancorp.a2.vpn.VPNTunnelNameService.lookupAllHostAddr VPN dns lookup result (private server IP)
2022-04-27 14:52:46,850 [Appian Work Item - 510542 - execution01 : UnattendedJavaActivityRequest] ERROR com.appian.ps.plugins.sftpsmartservices.SendFileOverSFTP - Error transferring file to SFTP server
4: java.io.IOException: inputstream is closed
	at com.jcraft.jsch.ChannelSftp._put(ChannelSftp.java:697)
	at com.jcraft.jsch.ChannelSftp.put(ChannelSftp.java:540)
	at com.jcraft.jsch.ChannelSftp.put(ChannelSftp.java:492)
	at com.appian.ps.plugins.sftpsmartservices.SendFileOverSFTP.run(SendFileOverSFTP.java:150)
	at com.appiancorp.process.runtime.framework.DefaultActivityExecutor$1.lambda$call$0(DefaultActivityExecutor.java:136)
	at com.appiancorp.plugins.PluginUsageLogger.runWithPluginInformation(PluginUsageLogger.java:52)
	at com.appiancorp.process.runtime.framework.DefaultActivityExecutor$1.call(DefaultActivityExecutor.java:136)
	at com.appiancorp.process.runtime.framework.DefaultActivityExecutor$1.call(DefaultActivityExecutor.java:130)
	at com.appiancorp.common.ContextClassLoaderSwitcher.runInContext(ContextClassLoaderSwitcher.java:27)
	at com.appiancorp.process.runtime.framework.DefaultActivityExecutor.execute(DefaultActivityExecutor.java:130)
	at com.appiancorp.process.engine.UnattendedJavaActivityRequest.execute(UnattendedJavaActivityRequest.java:88)
	at com.appiancorp.process.engine.UnattendedJavaActivityRequestResponseCreator.getJavaActivityResultResponse(UnattendedJavaActivityRequestResponseCreator.java:21)
	at com.appiancorp.process.engine.UnattendedJavaActivityRequest.getJavaActivityResultResponse(UnattendedJavaActivityRequest.java:67)
	at com.appiancorp.process.engine.UnattendedJavaActivityRequest.execute0(UnattendedJavaActivityRequest.java:55)
	at com.appiancorp.common.persistence.data.AppianDataUserContextProvider.executeWithConsistentDataReads(AppianDataUserContextProvider.java:116)
	at com.appiancorp.process.engine.ProcessContinuationRequest.executeOuter(ProcessContinuationRequest.java:68)
	at com.appiancorp.process.engine.ContinuationRequest.execute(ContinuationRequest.java:124)
	at com.appiancorp.process.workpoller.UnattendedRequestHandlerBean.onMessage(UnattendedRequestHandlerBean.java:36)
	at com.appiancorp.process.workpoller.WorkItem.run(WorkItem.java:94)
	at org.springframework.jca.work.SimpleTaskWorkManager$DelegatingWorkAdapter.run(SimpleTaskWorkManager.java:239)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:750)
Caused by: java.io.IOException: inputstream is closed
	at com.jcraft.jsch.ChannelSftp.fill(ChannelSftp.java:2911)
	at com.jcraft.jsch.ChannelSftp.header(ChannelSftp.java:2935)
	at com.jcraft.jsch.ChannelSftp.checkStatus(ChannelSftp.java:2473)
	at com.jcraft.jsch.ChannelSftp._put(ChannelSftp.java:686)
	... 22 more

Hi team,

for receive and send file over sftp does the plugin support also authentication with the public key? The requirements is to set in the Create Third-Party Credentials and add as credential not username and password, as usual, but directly the public key

Regards

Also would like to mention that we're on the latest version of this Plug-In 2.2.1

Hello, I am kindly requesting assistance with SFTP (Basic Credentials) plug-in. 

Over the course of several months, our application's success rate with this plug-in has decreased to less than 5%. We are on a cloud based application with different environment levels. In our TEST environment, we have never had issues connecting to the intended TEST server utilizing this plug-in. We have also tested connecting from our TEST environment to our PRODUCTION intended server file path, with success. However, when we try to connect to this PRODUCTION Server from our PRODUCTION environment utilizing this smart service, we are experiencing a very, very high failure rate. Note: This SFTP smart service is executed in a Process after a user has submitted a form. 

When the Send File SFTP (Basic Credentials) node is executed, we are able to establish a connection with the server (the username and password are accepted), a session is established and is open for ~10 minutes; however, the file gets sent over as blank with the error below. 

I have attached a screenshot of a log of a failed attempt. The PM error we always receive is the same: 

Error transferring file 4: java.io.IOException: inputstream is closed

Note: we have also attempted to send files that were generated hours / days prior to ensure that the document is in the Knowledge Center and that it does, in fact, contain data. 

I also want to inform that we are utilizing another smart service from this plug-in, Receive file from SFTP (Basic Credentials), and this is executed nightly. We have no failure rate with this plug-in component, in any environment. 

Other points to note regarding our troubleshooting efforts: 

1. We have implemented a timer that executes after the creation of the files to further ensure document(s) are generated.

2. Files are generated in a sub-process; thus, the smart service(s) creating the files must execute before the process finishes and moves forward in the parent. Files are also generated independently (one at a time) utilizing a smart service (Text Doc from Template), then these files are merged into an array of documents before exiting the sub-process. After sub-process has completed, the timer is executed ensuring delay in order to make sure generation is complete, which is beyond in the flow of the process. 

3. The size of these text files are also very very small (avg. size is 5Kb). Never a file has been over 30Kb. The server being connected to has no file size limitations in place. All files being sent are always same extension (.txt)

4. Our IP addresses are ensured that they're being accepted by the target server's firewall. 

Assistance to what logs to activate regarding further troubleshooting or other troubleshooting assistance is very much requested and appreciated. Thank you very much.