Folder Structure In Object Storage For POSTROUT Batch Extracts (Doc ID 2876157.1)

Last updated on JUNE 14, 2022

Applies to:

Goal

On: 21C version, Environment Related

The folder structure in Object Storage for POSTROUT batch extracts

When running POSTROUT batch (or ideally, any batch jobs that generate files in the Object Storage bucket), is there a way we can set a "folder" prefix? We'd like to organize files in a folder structure as outlined in the Object Storage documentation (https://docs.oracle.com/en-us/iaas/Content/Object/Tasks/managingobjects.htm) under the heading Object Naming Using Prefixes and Hierarchies.

We tried to run POSTROUT with the following parameters:
Test Run #1
- FILE-PATH: file-storage://CCS_SHARED/TEST_Export/Bills/
- FILE-NAME: POSTROUT_050422_11.xml

Test Run #2
- FILE-PATH: file-storage://CCS_SHARED/TEST_Export/
- FILE-NAME: Bills/POSTROUT_050422_11.xml

However, both runs resulted in a similar error message saying an error occurred while opening the extracted file.

ERROR:
-----------------
2022-05-04 23:34:56.871-0700 [84] ERROR com.splwg.base.domain.AppLog Failed to execute OCI Object Storage REST Api call: storeObject [correlationId=9b6ee321-f238-4197-92f1-b7c16f186056]
2022-05-04 23:34:56.873-0700 [84] ERROR com.splwg.base.domain.AppLog Error details: Status Message (Not Found), Status Code (404) , Error description {"code":"NotFound","message":"Not Found"} [correlationId=1946f368-0175-4b55-81de-9930450c1fa6]
2022-05-04 23:34:56.919-0700 [84] ERROR com.splwg.base.domain.common.message.ServerMessageFactory_Impl No message with Id Message_Id(messageCategoryId: [0], messageNumber: 0) [correlationId=d8b9a95c-3d24-4d3a-a85a-148f99ff8950]
2022-05-04 23:34:56.920-0700 [84] ERROR com.splwg.base.domain.common.message.ServerMessageFactory_Impl No message with Id Message_Id(messageCategoryId: [0], messageNumber: 0) [correlationId=0c2374d5-fe59-4446-ad15-bbd2b4820f59]
2022-05-04 23:34:56.983-0700 [84] ERROR com.oracle.ugbu.ouaf.batchServer.CloudThreadWorkerExecuteUnitWrapper Error executing batch work com.splwg.base.api.batch.ThreadAbortedException: com.splwg.base.support.program.NonZeroReturnCodeException(returnCd=2)
 

Solution

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