Load Data Using REST API Fails if Data File is not Located in the App/DB Directory, Job Error "API function (EssAsyncImport) does not work on client data object (/shared/dataload.txt)" (Doc ID 2971305.1)

Last updated on AUGUST 30, 2023

Applies to:

Symptoms

Using the REST API to load data with a data text file that is located in the catalog outside the application/database directory fails with the error "API function (EssAsyncImport) does not work on client data object that is location (/shared/dataload.txt)".

For example, using ASOSamp/Basic and loading a data text file located in the catalog/shared directory, the following Json payload starts to run but the Job Details in the Essbase UI returns the error:

{
"application": "ASOsamp",
"db": "Basic",
"jobtype": "dataload",
"parameters":
{

"rule": "dataload.rul",
"file" : "/shared/dataload.txt",
"abortOnError": true,
"useCatalogPath": true,
"useConnection" : false,
"loaddata": true
}
}

Cause

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