files not downloading from sftp

We can only guess ...

Any more details you can share?

I am using userid & password to connect sftp. 

for full file path getting below error :

ERROR com.appiancorp.ps.plugins.filetransfer.sftp.ReceiveFileOverSFTP - 2: No such file or directory

Are you sure you use the correct remote path?

Yes,

I am using below file path 

/Home/xyz/abc/uvw/test/Complete. I am getting success status but No such file or directory exist error description.

I am using below file path 

/Home/xyz/abc/uvw/test/Complete. I am getting success status but No such file or directory exist error description.

I guess your error occurs because the file path /Home/xyz/abc/uvw/test/Complete is likely incorrect due to case sensitivity and how your SFTP user’s root directory is configured.
Most SFTP servers use lowercase /home, not /Home, and the path you provide should be relative to the user’s home directory on the server.

To fix this, manually log in to the SFTP server using the same credentials to confirm the exact file path, paying attention to capitalization and directory structure. Then, adjust the path in Appian to match exactly.

If still fails: Add the file extension if "Complete" is a file (e.g. Complete.txt) or add a trailing slash if it's a folder (Complete/).