My Oracle Support Banner

SQL OCI Data Load Failing with Error “Error happened while EssOCI retrieved data with error message [ORA-24334: no descriptor for this position]” (Doc ID 2548169.1)

Last updated on MARCH 16, 2021

Applies to:

Hyperion Essbase - Version 11.1.2.4.000 and later
Information in this document applies to any platform.

Symptoms

Running a SQL data load is failing with the error:

1021101 - Error happened while EssOCI retrieved data with error message [ORA-24334: no descriptor for this position]

The application log has the following:

Received Command [Import] from user [<Username>] using [dataload.rul] with data file [SQL]

[Fri Apr 12 08:09:12 2019]Local/<appname>/<dbname>/<Username>/140000386029312/Info(1021040)
Substitution Variable in Data Source Name detected. Using: [$OCI$(DESCRIPTION=(LOAD_BALANCE= on)(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname>)(PORT = <portno>))(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname>)(PORT = <portno>))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = <servicename>)))] as DSN

[Fri Apr 12 08:09:12 2019]Local/<appname>/<dbname>/<Username>/140000386029312/Info(1021096)
EssOCI is enabled to extract data from the Oracle database

[Fri Apr 12 08:09:12 2019]Local/<appname>/<dbname>/<Username>/140000386029312/Info(1021006)
SELECT Statement [SELECT <select statement>] is generated

[Fri Apr 12 08:09:12 2019]Local/<appname>/<dbname>/<Username>/140000386029312/Info(1021097)
EssOCI is initializing the connection to Oracle database on server [(DESCRIPTION=(LOAD_BALANCE= on)(ADDRESS = (PROTOCOL = TCP)(HOST = <servername)(PORT = portno))(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname>)(PORT = <portno>))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = <servicename>)))]

[Fri Apr 12 08:09:12 2019]Local/<appname>/<dbname>/<Username>/140000386029312/Info(1021098)
EssOCI succeeded to connect to Oracle database

[Fri Apr 12 08:09:12 2019]Local/<appname>/<dbname>/<Username>/140000386029312/Info(1021000)
Connection With SQL Database Server is Established

[Fri Apr 12 08:09:12 2019]Local/<appname>/<dbname>/<Username>/140000386029312/Info(1003040)
Parallel dataload enabled: [16] block prepare threads, [1] block write threads.

[Fri Apr 12 08:23:32 2019]Local/<appname>/<dbname>/<Username>/140000282867456/Info(1021101)
Error happened while EssOCI retrieved data with error message [ORA-24334: no descriptor for this position]

 

 

Changes

 

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
Changes
Cause
Solution
References


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