首页 > 解决方案 > 如何将 ESSBase 立方体与 OBIEE 12 c 连接起来

问题描述

我正在使用 OBIEE 版本 12.2.1.4.0 和 ESSBase 版本 11.1.2,当我尝试将 OBIEE 与 ESSBase 多维数据集连接时,我收到以下错误连接失败 essbase 错误 0,有时我会收到其他错误错误代码如 46 请查找附件供您参考 在此处输入图像描述

请查找日志供您参考

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
]]

标签: obieeessbase

解决方案


感谢更新。这里参考官方认证矩阵:首先不支持在桌面操作系统上运行OBIEE 12.2.1.4:https://www.oracle.com/technetwork/middleware/obiee-122140-certmatrix-4472983 。 xlsx


推荐阅读