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 21.1.0.0.1 Marketplace and laterHyperion Essbase - Version 21.1.0.0.0 and later
Information in this document applies to any platform.
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
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
Symptoms |
Cause |
Solution |
References |