OBIEE 12c - 无法登录分析 [英] OBIEE 12c - cannot login to analytics
问题描述
能够访问 OBIEE 控制台和 EM,但无法登录到 Analytics.我已经为寻找解决方案而挠头了.任何建议都会在这里有所帮助.
Able to access OBIEE Console and EM but unable to login to Analytics. I have already scratched my head over searching for solutions all over. Any suggestion would help here.
[更新] - 不使用数据库身份验证或 BISQLProvider.在全新安装的 OBIEE 上使用 weblogic 登录
[Update] - Not using DB Authentication or BISQLProvider. Tying to login with weblogic on a fresh installation of OBIEE
我尝试过的步骤:
- 检查双服务器和管理服务器 - 都在运行
- 检查部署 - 全部运行
- 已检查 biplatform_datasource、mds_owsm、opss-data-source 和 wlsservices_datasource 的 JDBC 连接(从 EM-> Weblogic 域 -> JDBC 数据源)
EM 屏幕截图显示没有部署或服务器关闭:
EM Screenshot showing that no deployment or server is down:
Sawlog 错误如下:
Sawlog error below:
[2017-04-11T23:49:14+08:00] [OBIPS] [ERROR:1] [] [saw.securitysubsystem.checkauthentication.runimpl] [ecid: ] [tid: 5480] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: ] Odbc 驱动程序返回错误 (SQLDriverConnectW).状态:HY000.代码:10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] 发生一般错误.(HY000)状态:HY000.代码:73025.[nQSError:73025] Oracle BI Server 当前不可用于查询.请联系您的系统管理员报告故障.(HY000)[[文件:checkauthentication.cpp线路:1607地点:see.securitysubsystem.checkauthentication.runimpl锯.线程池.asynclogon锯线]]
[2017-04-11T23:49:14+08:00] [OBIPS] [ERROR:1] [] [saw.securitysubsystem.checkauthentication.runimpl] [ecid: ] [tid: 5480] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: ] Odbc driver returned an error (SQLDriverConnectW). State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000) State: HY000. Code: 73025. [nQSError: 73025] The Oracle BI Server is currently unavailable for queries. Please contact your System Administrator to report the failure. (HY000)[[ File:checkauthentication.cpp Line:1607 Location: saw.securitysubsystem.checkauthentication.runimpl saw.threadpool.asynclogon saw.threads ]]
[更新 2]:即使是 BI 服务器(OBIS 已启动):我还尝试完全卸载 OBIEE 并重新安装.在 config.cmd 之后,我只能使用管理员用户 (weblogic) 登录一次分析.一旦我重新启动服务,分析就不允许 weblogic 用户登录.我担心这可能是由于主机名问题,但主机名也是一致的.
[Update 2]: Even the BI Server (OBIS is up): I also tried uninstalling OBIEE completely and reinstalling it back. I was able to login to analytics with admin user (weblogic) only once after config.cmd. And as soon as I restarted the services, analytics did not allow login for weblogic user. I feared that it could be due to hostname issue but the hostname is consistent as well.
[更新 3 - 已解决]:可能是机器的 IP 地址在这里造成了问题.我将机器设置为静态 IP 地址,并在 Windows\System32\drivers\etc\hosts 中添加了主机名解析.这对我有用.感谢所有建议.
[Update 3 - Resolved]: Possibly the IP Address of the machine was creating a problem here. I set the machine to a static IP address and added a host name resolution in Windows\System32\drivers\etc\hosts. This did the trick for me. Thanks for all the suggestions.
推荐答案
[nQSError: 73025] Oracle BI Server 当前不可用于查询.
[nQSError: 73025] The Oracle BI Server is currently unavailable for queries.
^-- 您的屏幕截图仅显示管理服务器和托管服务器.Oracle BI Server (OBIS) 的实际状态如何?
^-- Your screenshot only shows admin server and managed server. What's the actual status of the Oracle BI Server (OBIS)?
目标导航 -> 商业智能 -> 双实例 -> 可用性
Target Navigation -> Business Intelligence -> biinstance -> Availability
这篇关于OBIEE 12c - 无法登录分析的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!