Essbase: Error Connecting to Oracle ODBC Driver Data Source Name(DSN) Using Essbase Load Rule or Calc Manager Rule with DATAEXPORT to DSN: "ODBC Layer Error: [IM004] ==> [[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed]" (Doc ID 2198983.1)

Last updated on AUGUST 17, 2023

Applies to:

Symptoms

When using Oracle ODBC driver based Data Source Name (DSN) to connect to Oracle Database from Essbase Dimension Build or Data Load Rule File or when Running a Calc Manager Rule with DATAEXPORT command exporting to Relational Database using this DSN, getting an error when trying to retrieve data in Essbase.

Application Log:

[TimeStamp]Local/appname/dbname/admin@Native Directory/4752/Info(1013091)
Received Command [SQLRetrieve] from user [UserName]

[TimeStamp]Local/appname/dbname/admin@Native Directory/4752/Info(1021004)
Connection String is generated

[TimeStamp]Local/appname/dbname/admin@Native Directory/4752/Info(1021041)
Connection String is [DSN=<DSN-Name>;UID=...;PWD=...;]

[TimeStamp]Local/appname/dbname/admin@Native Directory/4752/Info(1021006)
SELECT Statement [.......] is generated

[TimeStamp]Local/appname/dbname/admin@Native Directory/4752/Info(1021013)
ODBC Layer Error: [IM004] ==> [[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed]

Cause

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