Recently, when we tried to SFTP a file from PeopleSoft using an Application Engine , the process went to Success, but the SFTP failed with an error code of 8 – %Attachment_DestSysFailedLogin
Upon setting a trace for the AE, the logs returned an error message stating that the login was denied.
The URL was created that would reference the SFTP server and in the URL properties, the authentication type was set as PUBLIC KEY – information was provided for the Public key and Private key as well. Initial investigation revealed that the PeopleSoft system was unable to login to the SFTP server using the Public and Private keys. Further more, it appears that the Public and Private key files were copied over to a different custom directory instead of the PeopleSoft ID’s home directory.
Provided below is the URL property settings:
The following is the error message:
Here’s the error message in case you wanted to copy-paste-search:
PSCurlFileTransferSession : Upload : File Transfer Failed : FTP library Error code : 67 – Login denied
PSCurlFileTransferSession : MapErrorcode
ExecutePutAttachment : Return code : 8
ExecutePutAttachment : Error : AddAttachment failed : Cannot locate destination system for ftp
PSCurlFileTransferSession : Destructing the file transfer library object
Once the directory for the Public and Private keys were modified and the App server rebooted with clear cache, SFTP seemed to work fine.
If your PeopleSoft user ID is, says, psoftv, the home directory where the keys would have to be copied are:
Upon changing the directory for the keys, the trace file indicated that the SFTP file transfer was successful. In case you’re not able to view the sshkeys folder, see if the folder is hidden or not, inside the PeopleSoft ID’s home directory:
Hope this helps! 🙂