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:PeopleSoft Enterprise PT PeopleTools - Version 8.59 and later
Information in this document applies to any platform.
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.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document