Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

obiee 12c login taking time

Received Response
152
Views
8
Comments
gyilmaz
gyilmaz Rank 1 - Community Starter
edited Aug 13, 2024 5:57PM in Oracle Analytics Cloud and Server

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

  • asim cholas
    asim cholas Rank 6 - Analytics & AI Lead

    check your initialization blocks

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

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

  • gyilmaz
    gyilmaz Rank 1 - Community Starter

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

  • gyilmaz
    gyilmaz Rank 1 - Community Starter

    Hi Christian,

    authenticating oracle ldap and authorizing users with table.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

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

  • gyilmaz
    gyilmaz Rank 1 - Community Starter

    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]
    [Deleted User] Rank 2 - Community Beginner

    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
    Lamin J Rank 4 - Community Specialist

    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