Rows allowed for SFTP transfer in CSV

Question

Hi, 
 
 We are trying to generate CSV with 1 million rows. But when we try to transfer files over SFTP, the file transfer fails. 
 For less number of rows the SFTP transfer goes fine. 
 
 What is the rows allowed for SFTP file transfer?

kavyashreeh3453 · Accepted Answer

The issue was with multiple files loaded in the target directory. File transfer went fine after clearing the directory.

Mathieu Drouin · Answer

Did you try playing around with the timeout or the keepAliveTimeout in the configuration to see if it makes any difference?

Mike Schmitt · Answer

kavyashreeh3453 said: multiple files loaded in the target directory 
 In case this helps, most sFTP servers will require unique incoming filenames (something that is not a constraint within Appian, though it is in most systems). The way it handles conflict will vary depending on user permissions - if the FTP account has overwrite permission, then the new file will attempt to overwrite the original file with the same name. If not, I expect the FTP transaction would result in an error, which is probably what you were seeing.

Rows allowed for SFTP transfer in CSV

Top Replies