OBIEE 11g - Cannot connect to Essbase through OBIEE Admin Tool (Doc ID 1477575.1)

Last updated on JANUARY 17, 2014

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.6.0 to 11.1.1.6.2 BP1 [Release 11g]
Microsoft Windows (32-bit)
***Checked for relevance on 17-Jan-2014***

Symptoms

OBIEE 11.1.1.6 is installed in 64-bit Windows platform. When trying to connect to Essbase 11.1.2 Database (located in a 64bit Windows Platform) using the Admin tool from the OBIEE Server, user is able to successfully import the Essbase cubes.
Whereas, when trying to connect to Essbase Database using OBIEE standalone Admin tool from 32-bit Windows XP machine (OBIEE 11.1.1.6 client tool installation and Essbase client software 32bit install of Essbase 11.1.2.1 is installed in the same machine), user is unable to import.The import fails with following error message:

The Connection has failed. Essbase Error 8286

or

The Connection has failed. Essbase Error 2037


Changes

 The PATH environment variable and the ESSBASEPATH environment variable are set appropriately. 

Also added the PATH variable and the ESSBASEPATH variable to the bi_init.bat file present in the below path:
Oracle Business Intelligence Enterprise Edition Plus Client\oraclebi\orahome\bifoundation\server\bin\ bi_init.bat file

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