E-FTP: Error Attaching Files To OCI Object Storage Using PSFT File Attachment and Getting Error as "SetURLProperties (error): URL properties, URL object required OCIDs and keys, but one or all were not properly specified" in PT 8.59 (Doc ID 2855139.1)

Last updated on MAY 18, 2022

Applies to:

Symptoms

On : 8.59 version, File Attachments

Unable to attach Files to Oracle Cloud Infrastructure Object Storage using PSFT file attachment

Trying to configure the File attachment using Oracle Cloud Infrastructure Object Storage as a file repository, created the TEST URL and provided all the information under URL properties as per the given below doc but the files are not going to the OCI bucket.

Specifying Properties for HTTPS URLs : Products > Administration Tools > System and Server Administration > Using PeopleTools Utilities > Using Administration Utilities

ERROR in Application Server Logs
-----------------------
Getting below error while testing the File attachment using PeopleSoft Test utility:
SetURLProperties (error): URL properties, URL object "TEST", "Oracle Document Cloud" required "USER" and "PASSWORD", "OCI Object Storage" required OCIDs and keys, but one or all were not properly specified.

Error in SQL Trace
----------------------
PSAPPSRV.13521 (966) 1-11794  02.50.27 1824.894378       22:       &RETCODE = AddAttachment(@(&URL_ID), &ATTACHSYSFILENAME, &FILEEXTENSION, &ATTACHUSERFILE, &FILESIZE);
PSAPPSRV.13521 (966) 1-11795  02.50.27    0.000025 EvalAddAttachment: continuing from resume point.
PSAPPSRV.13521 (966) 1-11796  02.50.27    0.003760 EvalAddAttachment: processed URL object (on resume).
PSAPPSRV.13521 (966) 1-11797  02.50.27    0.000036 IsURLValid: masked specified URL = https://objectstorage.<masked>.oraclecloud.com
PSAPPSRV.13521 (966) 1-11798  02.50.27    0.000087 EvalAddAttachment: preparing to upload file to its ultimate destination on FTP server.
PSAPPSRV.13521 (966) 1-11799  02.50.27    0.000014 ExecutePutAttachment: entering.
PSAPPSRV.13521 (966) 1-11800  02.50.27    0.000013 ExecutePutAttachment: massaged destination file name.
PSAPPSRV.13521 (966) 1-11801  02.50.27    0.000750 SetURLProperties (error): URL properties, URL object "TEST", "Oracle Document Cloud" required "USER" and "PASSWORD", "OCI Object Storage" required OCIDs and keys, but one or all were not properly specified.
PSAPPSRV.13521 (966) 1-11802  02.50.27    0.000076 EvalAddAttachment (error): return code (1) indicates attempt to upload file to storage failed.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Get the tenancy OCID, user OCID, and fingerprint of the public API signing key for your Oracle Cloud Infrastructure account. See Required Keys and OCIDs in the Oracle Cloud Infrastructure online documentation,
2. Create a bucket and namespace for the files in Oracle Cloud Infrastructure Object Storage.See Overview of Object Storage in the Oracle Cloud Infrastructure documentation.
3. In your PeopleSoft environment, install an application server-based digital certificate.
4. In your PeopleSoft environment, create a new URL using https://.
5. Enter the Object Service Storage API endpoint in the URLID field on the URL Maintenance page. The Object Service Storage API endpoints are available in the Oracle Cloud Infrastructure online documentation.See API Reference and Endpoints.
6. Select URL Properties, and enter values for these properties:

• CLOUDREPOSITORY: Y
• CLOUDPROVIDER: OCI Object Storage
• BUCKETNAME: The name of the bucket you created in Object Storage.
• TENANCYOCID: The OCID for your Oracle Cloud Infrastructure tenancy.
• USEROCID: The OCID of the user calling the API.
• FINGERPRINT: The fingerprint for the API key pair being used.
• PRIVATEKEYPATH: The location for the API signing key pair.

7. Now Navigate to Peopletools Test Utilities page (Main Menu > Peopletools > Utilities > Debug > PeopleSoft Test Utilities page. Provide the URL ID and try to attach file. File does not get attached.

Changes

 NA

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.