OBIEE Problem Suddenly Goes Down — Oracle Analytics

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 Problem Suddenly Goes Down

Received Response
71
Views
10
Comments
dilek
dilek Rank 6 - Analytics Lead
edited Aug 13, 2024 5:55PM in Oracle Analytics Cloud and Server

Hello,

We have a huge problem on obiee. Especially, when I work on BI Publisher, although system services are up, browser can not open the sign in page. It just turns and wait for minutes. When we control system services, they are all up.

Here is the top command result; why java process use huge %CPU? Whenever the problem occurs, we see the java process on the first line:S

error.jpg

What can I do now? Can you help me?

Regards,

Dilek

Answers

  • dilek
    dilek Rank 6 - Analytics Lead

    Any idea please ? :S

    Thanks..

  • SonPat99
    SonPat99 Rank 6 - Analytics Lead

    Hi There,

    A better way to proceed can be checking the logs to see where the disconnect is happening.

    If you can see any errors, you can ask that.

  • dilek
    dilek Rank 6 - Analytics Lead

    Which log file should I look specifically? nqserver or biserver? I already see these log files but I do not understand where to look. Those files are huge and writes lots of things :S I am mixed and try to find more specific way to succeed

    Thank you

  • Charles M
    Charles M Rank 6 - Analytics Lead

    Hi dileraco,

    Try reviewing: bi_server1.log, bi_server1-diagnostic.log, and bi_server1.out. They should be in: [$FMW_HOME]/user_projects/domains/bifoundation_domain/servers/bi_server1/logs. These are the logs for the OBIEE managed server, itself. I think this is what you'll want. This is the java component. https://gerardnico.com/wiki/weblogic/java_component

    The nqserver, along with others, like nquery, sawlog, etc. are system components (non-java). Logs are under the $INSTANCE_TOP ...

    https://gerardnico.com/wiki/weblogic/java_component

    https://gerardnico.com/wiki/weblogic/system_component

    Regards,

    Charles

  • SonPat99
    SonPat99 Rank 6 - Analytics Lead

    Hello,

    As suggested by Charles, please check the log files of both Admin Server and BI_Server: especially the bi_server.out.

    you can see the logs present at end of the file (match it with your server timestamp and check the logs). You will definitely get some idea about the issue.

    Let us know if you find something that is useful.

    Cheers!!!

  • dilek
    dilek Rank 6 - Analytics Lead

    Ok, I will monitor these files. But bi_server1.out file does not exist for recent. For example, my problem occurred at 22 October, but no file exists for this date. :S An older version we have, which has 18 october :S Is this normal?

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

    Just to point sth out here that no one has considered yet.

    Since you dont specify WHAT exactly goes down but you say it haopens when doing BIP ... And BIP being java versus OBI being C++ ... Then maybe your problem is BIP and you must look at that component. Not the OBI components.

  • dilek
    dilek Rank 6 - Analytics Lead

    Should I look for BI Publisher component log files? @Christian Berg Do I understand correctly?

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

    Yes

  • Joel
    Joel Rank 8 - Analytics Strategist

    Check WebLogic as well, you may have some stuck threads:

    Oracle Support Document 1906192.1 (OBIEE 11g: Troubleshooting Stuck Threads or Hangs) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=1906192.1