My Oracle Support Banner

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 SEPTEMBER 27, 2019

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

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


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