Forum Stats

  • 3,741,287 Users
  • 2,248,404 Discussions
  • 7,861,720 Comments

Discussions

Unable to connect OBIEE Admin to Essbase

User_K7682
User_K7682 Member Posts: 5 Green Ribbon

Hi,

Last three weeks am trying to connect OBIEE Admin to Essbase, am not able to connect that, it shows some errors (Error 2097266) which I mentioned below.

my OBIEE Admin version - 12.2.1.4.0 and Essbase version - 11.1.2.4

OS - windows 10 64bit

Installation:-

  1. First, I have installed Essbase with all the diagnostics are passed.
  2. After that I have installed the Essbase Admin console, this one also working fine.

In OBIEE:-

I have created a new rpd, in that File -> Import metadata. this way am trying to connect.

Note :-

  1. OBIEE and Essbase are installed in the same machine in the "C:\Oracle\Middleware" folder
  2. I have tried with multiple Essbase server name like localhost, localhost: port, mycomputername, mycomputername : port

My previous ticket is still open with the same issue, for your reference

for your reference, I have mentioned log's also

[2021-07-22T17:24:39.45+05:30] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: 311c] Essbase Error 2097266 [[
file: C:\ADE\fanzha_h122140_24\biserver\analytics\server\Query\Execution\DbGateway\DbGatewayEssbaseCAPI\PrivateInclude\SQXDGEssbaseCAPIImport.h; line: 66]]
[2021-07-22T17:25:31.325+05:30] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: 311c] Essbase Error 2097266 [[
file: C:\ADE\fanzha_h122140_24\biserver\analytics\server\Query\Execution\DbGateway\DbGatewayEssbaseCAPI\PrivateInclude\SQXDGEssbaseCAPIImport.h; line: 66]]


My final aim is to want to get metadata in OBIEE from Essbase.

Please help me to fix this issue


Thanks

Tagged:

Comments

Sign In or Register to comment.