My Oracle Support Banner

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:

Essbase for OCI Marketplace - Version Marketplace and later
Hyperion Essbase - Version and later
Information in this document applies to any platform.


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",

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



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

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