Sunday, March 19, 2017

Fail to login to Oracle BIEE analytics page even though you know for sure that your analytics username and password are correct

This is a purely technical post , that i am writing primarily to remind myself about many issues that would face anyone trying to login to the oracle BI analytics page  (http://server:7001/analytics )


Two log files that you need to inspect

nqServer.log  located at  
C:\Middleware\instances\instance1\diagnostics\logs\OracleBIServerComponent\coreapplication_obis1

and swlog1 located at
C:\Middleware\instances\instance1\diagnostics\logs\OracleBIPresentationServicesComponent\coreapplication_obips1

in the swlog1 i got errors similar to 

[2017-03-19T19:18:10.000+03:00] [OBIPS] [ERROR:1] [] [saw.security.odbcuserpopulationimpl.getbisystemconnection] [ecid: 00ieQim1zLuFw0zlbq0CBz3aJzi3jwIx600010^000000,0:2487] [tid: 3188] Authentication Failure.
Odbc driver returned an error (SQLDriverConnectW).
State: 08004.  Code: 10018.  [NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested connection is refused.
[nQSError: 43113] Message returned from OBIS.
[nQSError: 43126] Authentication failed: invalid user/password. (08004)[[
File:odbcuserpoploaderimpl.cpp
Line:995
Location:
    saw.security.odbcuserpopulationimpl.getbisystemconnection


and in the nqServer  i got errors similar to 

[2017-03-19T19:18:09.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00ieQim1zLuFw0zlbq0CBz3aJzi3jwIx600010^000000] [tid: b48] Error Message From BI Security Service: SecurityService::authenticateUserWithLanguageUnexpected error authenticating user {0}
[2017-03-19T19:18:09.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00ieQim1zLuFw0zlbq0CBz3aJzi3jwIx600010^000000] [tid: b48]  [nQSError: 43126] Authentication failed: invalid user/password.



there are many reason why you get authentication failed   with [nQSError 43126]

in my case the problem was related to the fact that not all JDBC data sources where deployed on both the BI cluster, and the AdminServer Cluster, they were all deployed on the BI Cluster, and some on the AdminServer. Once , i deployed the jdbc data sources on the AdminServer in addition to the BI Cluster, and then rebounced the services, the problems disappeared.

However, other caused are present, i found a very helpful  document on metalink that summarizes all possible problems that are manifested by

nQSError: 43126] Authentication failed: invalid user/password.

please check the document below

Note: Such error is caused by OBIEE trying to access the database, because if you look above , there is ODBC and SQL involved  (repeated here)
  "Odbc driver returned an error (SQLDriverConnectW).
State: 08004.  Code: 10018.  [NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested connection is refused".  


That is why i was thinking Data Source immediately



OBIEE 11g: Error:" [nQSError: 43126] Authentication failed: invalid user/password." (Doc ID 1472848.1)


No comments:

Getting Ref of the View Object referenced by the current Iterator binding for One iterator page without knowing the name of the iterator

Getting Ref of the View Object referenced by the current Iterator binding for One iterator page without knowing the name of the iterator ...