OBIEE 12c - cannot login to analytics

weblogic weblogic12c obiee oracle-fusion-middleware oracle-bi
user3315307 picture user3315307 · Apr 11, 2017 · Viewed 12.6k times · Source

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.

[Update] - Not using DB Authentication or BISQLProvider. Tying to login with weblogic on a fresh installation of OBIEE

Steps I have tried:

  • Checked bi server and admin server - Both running
  • Checked deployments - all running
  • Checked JDBC connection (from EM-> Weblogic Domain -> JDBC Datasources) for biplatform_datasource, mds_owsm, opss-data-source and wlsservices_datasource

EM Screenshot showing that no deployment or server is down:

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

[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.

[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.

Answer

Soundarya Raghavula picture Soundarya Raghavula · Jun 9, 2020

Even I faced the below error :

You are not currently signed in to the Oracle BI Server If you have already signed in, your connection might have timed out, or a communications or server error may have occurred To sign in again, click here. If the problem persists, please contact the site's administrator.

Solution:

first go to weblogic----> servers-->bi server---> here change listen address to local host and port to analytics port and save it later stop all servers and start it, it works

Related questions

weblogic.application.ModuleException: Context path '' is already in use by the module: / application:

When i am trying to run weblogic server 12c , it is throwing this error and is unable to start. <Apr 16, 2013 2:42:57 PM IST> <Warning> <HTTP> <BEA-101384> <WLServlet annotation is deprecated, please use …

Read More
cannot start node manager

When I try to start node manager I am getting below error. I am getting this error on remote machine. By the way node manager is running on my local machine without any problem. Both machines have same configuration. Is …

Read More
Cannot find weblogic_home when setting up server in eclipse

I am trying to get my java ee development environment setup but am running into issues when trying to add a new server in eclipse. I have the oracle java ee version of eclipse, I also downloaded weblogic 12.1.2 and got …

Read More