E-FTP: File Attachment Transfers Fail When Using FTPS, SFTP, HTTP or HTTPS (Doc ID 1079524.1)

Last updated on APRIL 23, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.50 and later
Information in this document applies to any platform.
***Checked for relevance on 09-JAN-2014***

Symptoms

FTPS support was added in 8.50, while SFTP, HTTP and HTTPS support were added in 8.51.  When using one of the newly supported transfer protocols for file attachments, one of the following errors are seen:

*Note: the exact error differs from PeopleTools version to PeopleTools version

In Browser:

Attachment failed: Unable to login into destination system for ftp (137,9)

Or in PeopleCode Trace:

&RETCODE = ViewAttachment(&URL_ID, &ATTACHSYSFILENAME, &ATTACHUSERFILE);
...
ExecuteGetAttachment: Using FTP.
ExecuteGetAttachment: Return code : 160
ExecuteGetAttachment: Error : Peer certificate can not be authenticated with known CA certificate
ExecuteViewAttachment (error): return code (8) indicates attempt to download file from storage (for viewing) failed.
EvalViewAttachment (error): return code (8) indicates attempt to view file in storage failed.
EvalViewAttachment: finishing and returning 8.

Or in PeopleCode Trace:

ExecuteGetAttachment (error): Error: URL Identifier not provided. Use URL Identifier to connect.
EvalGetAttachment (error): return code (1) indicates attempt to download file from storage failed.
EvalGetAttachment: finishing and returning 1.


The example above uses ViewAttachment, but the same applies to AddAttachment, PutAttachment and GetAttachment.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms