I am facing a wiered issue all my services are up and running Yet i am unable to login to the Portal.
looking into the logs:
Log from OBIPS:
[OBIPS] [ERROR:1] [] [saw.security.odbcuserpopulationimpl.getbisystemconnection] [ecid: ] [tid: ] 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)[[
Log from OBIS nqserver.log
[nQSError: 12010] Communication error connecting to remote end point: address = saleem; port = 7001.
[nQSError: 46119] Failed to open HTTP connection to server saleem at port 7001.'
]]
Solution:
Navigate to Business Intelligence -> coreapplication ->Capacity Management' tab -> 'Scalability' sub-tab
Click on 'Lock and Edit Configuration' button
Enter the IP address in the 'Listen Address' field
Click on 'Activate Changes' followed by 'Release Configuration' buttons
Restart BI Server and Presentation Services.
After Adding the Listener Address my issue was resolved.
Core Issue behind the scenes:
Please have loop back adapter installed in your system. My server IP changed when i connected to internet and it was the issue.
looking into the logs:
Log from OBIPS:
[OBIPS] [ERROR:1] [] [saw.security.odbcuserpopulationimpl.getbisystemconnection] [ecid: ] [tid: ] 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)[[
Log from OBIS nqserver.log
[nQSError: 12010] Communication error connecting to remote end point: address = saleem; port = 7001.
[nQSError: 46119] Failed to open HTTP connection to server saleem at port 7001.'
]]
Solution:
Navigate to Business Intelligence -> coreapplication ->Capacity Management' tab -> 'Scalability' sub-tab
Click on 'Lock and Edit Configuration' button
Enter the IP address in the 'Listen Address' field
Click on 'Activate Changes' followed by 'Release Configuration' buttons
Restart BI Server and Presentation Services.
After Adding the Listener Address my issue was resolved.
Core Issue behind the scenes:
Please have loop back adapter installed in your system. My server IP changed when i connected to internet and it was the issue.
Thanks saleem for this blog
ReplyDeleteHi Saleem, Thanks a lot for your updates which remain quite helpful. I face the problem as unable to login while all my services shows 100% running with no red flag at all. INspite face the problem over the last 10 days+ as unable to connect. The logs shows the same error as what listed by you above.
ReplyDelete[2017-05-25T12:10:17.000+05:30] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00ifib6wt3AEwGWzLwYROA0001I8000006] [tid: cf4]
[nQSError: 43126] Authentication failed: invalid user/password.
[2017-05-25T12:10:18.000+05:30] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 00ifib6DKuwEwGWzLwYROA0001Dw000000] [tid: d88] Could not connect to the authentication web service (taking OBIS offline) 0.1.0.6:
[nQSError: 12002] Socket communication error at call=Connect: (Number=0) Call=NQRpc: An unknown socket communications error has occurred. [[
[nQSError: 12010] Communication error connecting to remote end point: address = 0.1.0.6; port = 7001.
[nQSError: 46119] Failed to open HTTP connection to server 0.1.0.6 at port 7001.
]]
Based on your solution I'm not sure of with what listener address to provide given mine is a standalone and not connected to internet as it's on VMWare. Can you please advice.
The other log recorded as below
ReplyDelete[2017-05-25T12:50:17.000+05:30] [OBIPS] [ERROR:31] [] [saw.security.odbcuserpopulationimpl.getbisystemconnection]
[ecid: 00ifib6WPbwEwGWzLwYROA0001I8000000,0:520]
[tid: 4740] Unable to create a system user connection to BI Server while running user population queries Odbc driver
returned an error (SQLDriverConnectW).
State: HY000. Code: 10058.
[NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
[nQSError: 73006] Cannot obtain Oracle BI Servers from either the primary Cluster Controller (prisam) or the
secondary Cluster Controller () specified for the clustered DSN.
(HY000)[[File:odbcuserpoploaderimpl.cpp
Line:1018
Location:
saw.security.odbcuserpopulationimpl.getbisystemconnection
saw.security.odbcuserpopulationimpl.searchidentities
saw.security.userpopulationmanagerimpl.searchidentities
saw.catalog.dirCache.getAllSharedFolders
saw.CatalogAttributes.cache.cleanup
saw.taskScheduler.processJob
saw.threadpool.taskscheduler
saw.threads
ecid: 00ifib6WPbwEwGWzLwYROA0001I8000000,0:520
ThreadID: 4740
task: Cache/CatalogAttributes
]]