OBIEE hang — Oracle Analytics

Oracle Analytics Cloud and Server

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

OBIEE hang

Received Response
121
Views
15
Comments
marcobalduini
marcobalduini Rank 4 - Community Specialist

Hi gurus,

we have recently migrated to OBIEE 12.2.1.2.0 version,

production installation has been done on a clustered environment;

OBIEE access is managed by a load balancer

shared resources (catalogue, rpd, etc.) are stored in a shared folder.

Users acceses trough company active directory.

We have the following issue: apparently in a random way the system freeze for at least one minute.

Some cases

- trying logging-in; the home page display the page stating "Signin in..."

- if you're already inside the system perform every action (for example going from the Home Page to the Catalogue Page)

- connecting to the on line repository with Admin Tool

- connecting to EM

after the freeze everything works fine. The system is smooth and responsive.

On server side nothing looks wrong, no logs give us a clue about the issue.

We have also tried to move shared files to one server simulating no-clustered environment but the issue is still there.

No stuck thread. No lack of heap memory.

Is there any action we can perform to identify the issue? Could you please provide some help?

Thanks in advance

Marco

«1

Answers

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

    Are you sure it's not just a browser issue? Are you using IE by any chance?

  • marcobalduini
    marcobalduini Rank 4 - Community Specialist

    Hi Christian,

    thanks for your unswer,

    we are doing our tests with all most common browsers (IE, Chrome, Firefox)

    disabling browser cache

    and also setting up Firefox cache as suggested in Oracle documentation.

    Unfortunately I dont't think it's a browser issue.

    M

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

    Ok. What are you using in terms of security? LDAP or MSAD tied in? Are maybe your authentication queries running slow or can't connect to the security providers?

  • marcobalduini
    marcobalduini Rank 4 - Community Specialist

    We use MSAD, not shure about connection issue; how can I check?

    Looking at various logs I didn't find any error and also doing a server thread dump didn't gave us evidence of slow queries.

    Is there any specific place where we can look in?

    I have to add that we use MSAD users and "local" users (created directly in console) and the issue happens for both users.

    Thanks again for your help,

    Marco

  • Rajesh Dhanapal
    Rajesh Dhanapal Rank 4 - Community Specialist

    Hi Marco,

    Try to create a new user directly in the weblogic console and you can test it.

    Does the weblogic user have the same problem?

    Best regards,

    Rajesh Dhanapal.

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

    Pump up the security logging as stated here:

    As for "it happens for both users"... if MSAD is the first security provider in the sequence and hangs due to a slow query then the login will be slow nevertheless because security providers are parsed sequentially.

  • marcobalduini
    marcobalduini Rank 4 - Community Specialist

    Hi Rajesh,

    we already use both MSAD and "console" users and the issue is there for all of them.

    Thanks for your answer,

    Marco

  • marcobalduini
    marcobalduini Rank 4 - Community Specialist

    thanks Christian,

    going to try this and let you know.

    Kind regards,

    Marco

  • Michael Verzijl
    Michael Verzijl Rank 6 - Analytics Lead

    In your MSAD configuration, do you have Follow Referrals enabled?

    I have seen this behavior in the past while using MSAD

  • Rajesh Dhanapal
    Rajesh Dhanapal Rank 4 - Community Specialist

    Hi Marco,

    Try to upload the sample RPD and check whether you can login.

    Then try to download the your corporate RPD and upload the previous version of the RPD to check it.

    Best regards,

    Rajesh Dhanapal.