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?
Discussion posts and replies are publicly visible
If the file transfer fails, it probably has more to do with the size of the file than the number of rows.
Do you know what the size of the file is?
All the files we are trying are less than 150 MB.
OK but what are the sizes of both files (over 1M and under 1M)?
How much time does the under 1M file transfer take to complete?
Excel tools allow only a million rows so that consumes up to 180 MB and takes few seconds for file transfer.
But the error I am getting is very generic. The error just says "Failure" no further info.
Did you look at the logs?
Yes no specific explanation in logs as well.
Did you try playing around with the timeout or the keepAliveTimeout in the configuration to see if it makes any difference?
The issue was with multiple files loaded in the target directory. File transfer went fine after clearing the directory.
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.