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

2671324

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

SunilSharma

refresh GUID's will help u here

SunilSharma

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

2671324

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

refresh GUID's will help u here

2671324

hi

yes it works

can you just explain what is this GUID ?

TIA

SriniVEERAVALLI

Check this cool-bi.com

SunilSharma

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