SFTP Smart Services

It seems like there is an invalid filename. What are the sftpServerFilePath and documentName parameters you are passing in?

Are you perhaps trying to pull a file that doesn't have an extension?

I'm also running into same issue 

2020-10-12 17:52:03,309 [Appian Work Item - 10843 - execution01 : UnattendedJavaActivityRequest] ERROR com.appiancorp.process.engine.UnattendedJavaActivityRequest - An error occurred while executing activity: id=268465328, classname=com.appian.ps.plugins.sftpsmartservices.ReceiveFileOverSFTPBasic
java.lang.StringIndexOutOfBoundsException: String index out of range: -1
at java.lang.String.substring(String.java:1927)
at com.appian.ps.plugins.sftpsmartservices.ReceiveFileOverSFTPBasic.run(ReceiveFileOverSFTPBasic.java:103)
at com.appiancorp.process.runtime.framework.DefaultActivityExecutor$1.lambda$call$0(DefaultActivityExecutor.java:131)
at com.appiancorp.plugins.PluginUsageLogger.runWithPluginInformation(PluginUsageLogger.java:52)
at com.appiancorp.process.runtime.framework.DefaultActivityExecutor$1.call(DefaultActivityExecutor.java:131)
at com.appiancorp.process.runtime.framework.DefaultActivityExecutor$1.call(DefaultActivityExecutor.java:125)
at com.appiancorp.common.ContextClassLoaderSwitcher.runInContext(ContextClassLoaderSwitcher.java:25)
at com.appiancorp.process.runtime.framework.DefaultActivityExecutor.execute(DefaultActivityExecutor.java:125)
at com.appiancorp.process.engine.UnattendedJavaActivityRequest.execute(UnattendedJavaActivityRequest.java:83)
at com.appiancorp.process.engine.UnattendedJavaActivityRequest.execute0(UnattendedJavaActivityRequest.java:55)
at com.appiancorp.process.engine.ContinuationRequest.executeOuter(ContinuationRequest.java:71)
at com.appiancorp.process.engine.ContinuationRequest.execute(ContinuationRequest.java:100)
at com.appiancorp.process.workpoller.UnattendedRequestHandlerBean.onMessage(UnattendedRequestHandlerBean.java:36)
at com.appiancorp.process.workpoller.WorkItem.run(WorkItem.java:93)
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:748)

Code at 103: ReceiveFileOverSFTPBasic

if (documentName.lastIndexOf('.') == -1)
documentName += remote_filename.substring(remote_filename
.lastIndexOf('.'));

I see that there is a single Send File over FTP, but there doesn't seem to be a smart service for sending a single file over FTPS.  This would most likely have to be an enhancement to the plugin.

Can you include the stack trace from the tomcat-stdout.log to get more information on what is throwing this exception?

Is your variable that you are saving the output of the rule into a multiple? That smart service returns two arrays files[] and directories[]

This function is simply running an ls command on the SFTP server.  Then it loops through each of the contents and runs the following logic:

If content.getLongname() start with d then add to the directory array, otherwise add to file array (unless ".." or "." which are filtered out)

Are you checking both of the output arrays (documents and files)?

I would test with an SFTP client like WinSCP and see if you have the same issue.  It may be a user permission issue on those files.

There is a limit of the smart service of an hour, but no specific timeout set in the code for the plug-in.  

That being said, an 18GB is very large - what are your plans for using it in Appian?  Additionally, it will use up a lot of Appian's disk space.

Hi Team,

Using the "Retrieve Files in Folders over FTPS", i was able to download all files from folder when i specify the folder path.

But if i specify a single file along with it's path, then the file is downloading as <1 KB file and not able to download and open.

Please help me , on how to download single file using this plugin ?

Thanks in advance....

I am using v2.0 I am not able to receive file by using "Receive File Over SFTP (Basic Credentials). 

It is giving error, "String index out of range : -1".

"Send File Over SFTP (Basic Credentials) " is working fine and I am able to send file to the remote site.

Any help on this will be appreciated.

Thanks