nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

weblogic user not able to login to Analytics, EM and Admin are fine

Hesh

Hi,

OBIEE 12c

There was some issue with AD users, I have created one temporary weblgoic user in Admin. Thereafter I can not login even with weblogic user! before this temp user creation weblogic user was fine.

[2017-10-04T11:14:05+01:00] [OBIPS] [NOTIFICATION:1] [] [saw.securitysubsystem.checkauthentication.runimpl] [ecid: 32947c87-101b-4185-9c5b-21eb29e52820-000000e3,0:1:1] [tid: 1769338624] [SI-Name: ]

[IDD-Name: ] [IDD-GUID: ] [userId: ] 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.

(08004)

State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS.

(HY000)

State: HY000. Code: 43126. [nQSError: 43126] Authentication failed: invalid user/password. (HY000)[[

File:checkauthentication.cpp

Line:1534

Location:

saw.securitysubsystem.checkauthentication.runimpl

saw.threadpool.asynclogon

saw.threads

]]

Thanks

Hesh

Find more posts tagged with

Accepted answers

All comments

Michael Verzijl

What is the order of the providers in console right now? Could you make sure DefaultAuthenticator is set to the first?

Did you recently configured AD?

What is the exact version of OBIEE you are running right now?

[Deleted User]

0.) Edit: Obviously back up the environment first!

1.) WLS LDAP - so the "Default Authenticator" - first in the sort order of security providers

2.) Mark it as SUFFICIENT so it lets you through as soon as it passes the check "is this user in the WLS LDAP?"

3.) If you really want to be sure that AD isn't used remove the virtualize=true in the security provider configuration so that only the first provider will be chosen

Hesh

Thanks Christian, Michael,

From config file the version is 12.2.1.0.0

This is how Providers view in Admin console

Thanks

Hesh

Michael Verzijl

Did you just recently configured AD?

Is virtualize enabled in EM?

Hesh

Hi Christian

Both DefaultAuthenticator and ADAuthenticator have SUFFICIENT in Control Flag.

How to understand Order of providers? I did not find anywhere!

Regards

Hesh

[Deleted User]

1st, 2nd, 3rd...see the reorder button?

Hesh

Thanks Christian,

Do you think Trust Service Identity Asserter causing the issue here? what is that for?

[Deleted User]

I took a screenshot of one of my environments. Yours must have at least the second and third.

Hesh

Christian,

I can not view any screenshot!

One from my team believes there is some keystore issue, as he finds may errors in the log. Not sure where this heading now..

Regards

Hesh

This issue has been resolved now.

Admin contacted Oracle, they thought certificate expire issue was causing this issue.We did a import of certificates and it worked.

Not very sure if this is the reason as we did the import few times even before contacting Oracle but did not work!