OBIEE Problem Suddenly Goes Down

dilek

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

What can I do now? Can you help me?

Regards,

Dilek

dilek

Any idea please ? :S

Thanks..

SonPat99

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

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

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

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

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]

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

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

[Deleted User]

Yes

Joel

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