Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
obiee 12c login taking time
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
Answers
-
check your initialization blocks
0 -
First question: How is your security set up? How are you authenticating and authorizing users?
0 -
Hi asim, we checked initialization block(it has a simple sql) and did not see any wrong thing.
0 -
Hi Christian,
authenticating oracle ldap and authorizing users with table.
0 -
And WHAT takes long? Authentication? Authorization? The already mentioned initialization blocks which fire in the RPD?
0 -
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)
0 -
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...
0 -
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
0