I'm using OBIEE version 12.2.1.4.0 and ESSBase version 11.1.2, when I'm trying connect the OBIEE with ESSBase cube I'm getting error below
The connection has failed essbase error 0, and sometime I'm getting other error code like 46
Please find attached for your reference
please find log for your reference
2021-07-22T22:24:12.992+05:30] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: 2d8c] Essbase Error 46 [[
file: C:\ADE\fanzha_h122140_24\biserver\analytics\server\Query\Execution\DbGateway\DbGatewayEssbaseCAPI\PrivateInclude\SQXDGEssbaseCAPIImport.h; line: 66
]]
[2021-07-22T22:25:29.579+05:30] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: 2d8c] Essbase Error 46 [[
file: C:\ADE\fanzha_h122140_24\biserver\analytics\server\Query\Execution\DbGateway\DbGatewayEssbaseCAPI\PrivateInclude\SQXDGEssbaseCAPIImport.h; line: 66
]]
[2021-07-22T22:25:39.700+05:30] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: 2d8c] Essbase Error 46 [[
file: C:\ADE\fanzha_h122140_24\biserver\analytics\server\Query\Execution\DbGateway\DbGatewayEssbaseCAPI\PrivateInclude\SQXDGEssbaseCAPIImport.h; line: 66
]]
[2021-07-22T22:26:13.276+05:30] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: 2d8c] Essbase Error 46 [[
file: C:\ADE\fanzha_h122140_24\biserver\analytics\server\Query\Execution\DbGateway\DbGatewayEssbaseCAPI\PrivateInclude\SQXDGEssbaseCAPIImport.h; line: 66
]]
[2021-07-22T22:26:53.280+05:30] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: 2d8c] Essbase Error 7274601 [[
file: C:\ADE\fanzha_h122140_24\biserver\analytics\server\Query\Execution\DbGateway\DbGatewayEssbaseCAPI\PrivateInclude\SQXDGEssbaseCAPIImport.h; line: 66
]]
[2021-07-22T22:27:41.163+05:30] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: 2d8c] Essbase Error 7274601 [[
file: C:\ADE\fanzha_h122140_24\biserver\analytics\server\Query\Execution\DbGateway\DbGatewayEssbaseCAPI\PrivateInclude\SQXDGEssbaseCAPIImport.h; line: 66
]]
]]
[2021-07-23T09:56:30.568+05:30] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ] [tid: e28] LCMAPIsUtil.GetSDD-> C:\Oracle\Middleware\Oracle_Home\bi\bin\..\..\user_projects\domains\bi\bidata
[2021-07-23T09:56:30.625+05:30] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ] [tid: e28] Reading ServiceInstanceKey from file: C:\Oracle\Middleware\Oracle_Home\bi\bin\..\..\user_projects\domains\bi\bidata\components\OBIS\instance_mapping\obis1\mapping.xml [[
file: server\Utility\Server\Config\SUSystemConfig.cpp; line: 1371
]]
[2021-07-23T09:56:30.648+05:30] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ] [tid: e28] Found service instance key: ssi for component:obis1 [[
file: server\Utility\Server\Config\SUSystemConfig.cpp; line: 1562
]]
[2021-07-23T09:56:30.674+05:30] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ] [tid: e28] LCMAPIsUtil.GetSDD-> C:\Oracle\Middleware\Oracle_Home\bi\bin\..\..\user_projects\domains\bi\bidata
[2021-07-23T09:56:30.702+05:30] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ] [tid: e28] LCMAPIsUtil.GetSDD-> C:\Oracle\Middleware\Oracle_Home\bi\bin\..\..\user_projects\domains\bi\bidata
[2021-07-23T09:56:30.774+05:30] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: e28] [46158] Admintool is using language ENU.
[2021-07-23T09:56:50.620+05:30] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: e28] Opening call for File=C:\Oracle\Middleware\Oracle_Home\bi\bifoundation\server\TestEssbase.rpd, ID=11713544998400275304_14988947945299578211, LogicalName: OfflineRepository
[2021-07-23T09:56:57.184+05:30] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: e28] Essbase Error 2097266 [[
file: C:\ADE\fanzha_h122140_24\biserver\analytics\server\Query\Execution\DbGateway\DbGatewayEssbaseCAPI\PrivateInclude\SQXDGEssbaseCAPIImport.h; line: 66
]]
