OBIEE Login Failure Communication Error

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.

3 comments:

  1. Hi 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.

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

    ReplyDelete
  2. The other log recorded as below

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

    ReplyDelete