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

obiee 12c login taking time

gyilmaz

Hi,

We have migrated complete OBIEE 11.1.1.7 to obiee12.2.1.1 but after migration

when user logs in its taking time(sometimes 1 minute sometimes 10 minutes) and when we check sawserver log we found below error.

How can we solve this?

Thanks for advice..

[saw.security.securityimpl.internaladdauthenticateduser] [ecid: ....................] [tid: ..............] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: ] User <user> cannot access his home directory due to mismatched GUIDs.[[

File:securityimpl.cpp

Line:736

Location:

saw.security.securityimpl.internaladdauthenticateduser

saw.security.securityimpl.addauthenticatedusernonproxy

saw.securitysubsystem.authenticationutils.addauthenticatedusertocatalog

saw.securitysubsystem.checkauthentication.runimpl

saw.threadpool.asynclogon

saw.threads

Find more posts tagged with

Accepted answers

All comments

asim cholas

check your initialization blocks

[Deleted User]

First question: How is your security set up? How are you authenticating and authorizing users?

gyilmaz

Hi asim, we checked initialization block(it has a simple sql) and did not see any wrong thing.

gyilmaz

Hi Christian,

authenticating oracle ldap and authorizing users with table.

[Deleted User]

And WHAT takes long? Authentication? Authorization? The already mentioned initialization blocks which fire in the RPD?

gyilmaz

we write user id and password, sometimes we login at 2 seconds and sometimes at 10 minutes.

Init bloks in general rpd.(in one rpd)

[Deleted User]

So you have identified the exact thing that is slow? It's the initialization blocks which produce queries that are running slowly?

Having a hard time understanding whether you found the root cause of your issue or whether you're still searching for then issue...

Lamin J

Hi gyilmaz!

If you optimized the queries as much as possible inside the initialization blocks you could then hava look at Allow Deferred Execution.

Since you are having issues with login times.

Link: https://docs.oracle.com/cd/E28280_01/bi.1111/e10540/variables.htm#BIEMG3104