My Oracle Support Banner

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 to BP1 [Release 11g]
Microsoft Windows (32-bit)
***Checked for relevance on 17-Jan-2014***


OBIEE 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 client tool installation and Essbase client software 32bit install of Essbase 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


The Connection has failed. Essbase Error 2037


 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


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

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