OBIEE 12c JavaHost tmp grows and grows

Alex Sharkov

Hi all

on ver OBIEE 12c 12.2.1.2

under dir

/home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/bi/system_components/OBIJH/obijh1/tmp/

i see a lot of huge files

Why files exists under this dir? Can i remove files.

On 11g all temporary files removes automaticaly. Why 12c don't remove?

Syedsalmancs110

What are the file types(extensions) that exists within Java Host tmp directory?

What is the log level set for Java Host in EM, is it default or finest?

Also check if any additional logging for Excel and PDF export is enabled for Java Host causing generation of huge files.

OBIEE 11g|12c: How To Enable JavaHost Logging to Capture Export (PDF/Excel ) and Graph/Chart Requests (Doc ID 1966917.1)

[Deleted User]

What host OS are you running 12.2.1.2 on? JH tmp folders get cleaned nicely on OEL7 and Windows2k12.

Alex Sharkov

I see only

*.javahost.in

*.javahost.out

there is no log files

My OS version is

RedHat 7

Linux appbiprod-12c.hq.bc 3.10.0-514.21.1.el7.x86_64 #1 SMP Sat Apr 22 02:41:35 EDT 2017 x86_64 x86_64 x86_64 GNU/Linux

by the way

i have in javahost config

   <XMLP>

      <InputStreamLimitInKB>0</InputStreamLimitInKB>

      <ReadRequestBeforeProcessing>false</ReadRequestBeforeProcessing>

      <LogLargeRequests>true</LogLargeRequests>

   </XMLP>

Is       <LogLargeRequests>true</LogLargeRequests> may generate huge datafiles under /home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/bi/system_components/OBIJH/obijh1/tmp/  ?

Syedsalmancs110

Yes looks like your Advanced Logging for Java Host is enabled and may be you are performing report export which are significant in size because of which response file is written in tmp directory, Please see the document link shared before it clearly states the same

OBIEE 11g|12c: How To Enable JavaHost Logging to Capture Export (PDF/Excel ) and Graph/Chart Requests (Doc ID 1966917.1)

[Deleted User]

Syed was faster. Any reason why your instanceconfig is set up like this?

Alex Sharkov

Thanks!

We did work on issue with export very huge XLS files.

Seem's to be we forget switch off this