Forum Stats

  • 3,784,367 Users
  • 2,254,929 Discussions
  • 7,880,793 Comments

Discussions

Obiee 11g migration : weblogic user unable to login into Analytics

hello

we have just migrate  obiee 11g successfully from one server to another server.

but now after migration we are not able to login into analytics page with weblogic user.

this user weblogic is able to login to Console and EM but not in analytics page.

All other user can log into console , EM and Analytics page.

so far ,

we have tried trobleshooting with following links,

1.

2. also tried with deleting weblogic user and again created weblogic user.

   but no luck.

Note : i have noticed when we migrated users and roles from one server to another , then weblogic user was working fine , even could login to Analytics page.

         But as soon as we migrated and deployed RPD, only since then we are facing this issue.

does any one have idea on this.

TIA

Best Answer

Answers

  • SunilSharma
    SunilSharma Member Posts: 1,688

    check the errors in nqserver and sawserver log files. Also Did you try with refresh GUID's?

    SunilSharma
  • 2671324
    2671324 Member Posts: 13

    hi

    error from nqserver:

    [2014-05-23T06:51:58.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 11d1def534ea1be0:41e5dd41:1462888bbde:-8000-00000000000005a8,0:1:1:6] [tid: 13fc]  [nQSError: 13041] The GUID of user 'weblogic' does not match user reference GUID at the repository. Please ask the administrator to delete the old user reference at the repository and login again.

    [2014-05-23T06:51:58.000-07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 11d1def534ea1be0:41e5dd41:1462888bbde:-8000-00000000000005a8,0:1:1:6] [tid: 13fc]  [nQSError: 43126] Authentication failed: invalid user/password.

    error from sawlog0 :

    [2014-05-23T06:51:59.000-07:00] [OBIPS] [ERROR:31] [] [saw.connectionPool.getConnection] [ecid: 11d1def534ea1be0:41e5dd41:1462888bbde:-8000-00000000000005a8,0:1:1] [tid: 4008] 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:connection.cpp

    Line:436

    Location:

        saw.connectionPool.getConnection

        saw.securitysubsystem.checkauthentication.runimpl

        saw.threadpool.asynclogon

        saw.threads

    ecid: 11d1def534ea1be0:41e5dd41:1462888bbde:-8000-00000000000005a8,0:1:1

    ThreadID: 4008

    ]]

    [2014-05-23T06:51:59.000-07:00] [OBIPS] [NOTIFICATION:1] [] [saw.securitysubsystem.checkauthentication.runimpl] [ecid: 11d1def534ea1be0:41e5dd41:1462888bbde:-8000-00000000000005a8,0:1:1] [tid: 4008] 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:checkauthentication.cpp

    Line:1330

    Location:

        saw.securitysubsystem.checkauthentication.runimpl

        saw.threadpool.asynclogon

        saw.threads

    ecid: 11d1def534ea1be0:41e5dd41:1462888bbde:-8000-00000000000005a8,0:1:1

    ThreadID: 4008

    ]]

  • SunilSharma
    SunilSharma Member Posts: 1,688
    Accepted Answer

    refresh GUID's will help u here

  • 2671324
    2671324 Member Posts: 13

    hi

    yes it works

    can you just explain what is this GUID ?

    TIA

  • SriniVEERAVALLI
    SriniVEERAVALLI Member Posts: 8,539 Gold Crown
    edited May 23, 2014 4:43PM
  • SunilSharma
    SunilSharma Member Posts: 1,688

    read through this http://docs.oracle.com/cd/E14571_01/core.1111/e10105/testprod.htm#CHDDJHHJ

    GUID is basically a Global Unique identifier assigned for every user created in the system. If there is a mismatch in that ID between the same user who got copied and who is already exist then u will face these login issues, so a refresh will regenerate them and sync it across system

This discussion has been closed.