Essbase: Error Using Oracle ODBC Driver in SQL Interface "ODBC Layer Error: [IM004] ==> [[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed]" (Doc ID 2198983.1)

Last updated on NOVEMBER 01, 2016

Applies to:

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

Symptoms

When using Oracle ODBC driver based Data Source Name (DSN) to connect to Oracle Database from SQL Interface, getting an error when trying to retrieve data in Essbase.

Application Log:

[Wed Aug 31 15:22:21 2016]Local/appname/dbname/admin@Native Directory/4752/Info(1013091)
Received Command [SQLRetrieve] from user [admin@Native Directory]

[Wed Aug 31 15:22:21 2016]Local/appname/dbname/admin@Native Directory/4752/Info(1021004)
Connection String is generated

[Wed Aug 31 15:22:21 2016]Local/appname/dbname/admin@Native Directory/4752/Info(1021041)
Connection String is [DSN=ORANEW;UID=...;PWD=...;]

[Wed Aug 31 15:22:21 2016]Local/appname/dbname/admin@Native Directory/4752/Info(1021006)
SELECT Statement [.......] is generated

[Wed Aug 31 15:22:21 2016]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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms