Very large HEAPDUMP files are generated when executing BI Web reports NW7.0

[Former Member]

Dear Gurus,

I´m facing a new problem.

When few users are working in Portal to execute BI Web reports and queries, the system stops and big files are generated in directory: /usr/sap/BWQ/DVEBMGS42/j2ee/cluster/server0

I´m using AIX 5.3. The files are these:

2354248 Sep 29 12:31 Snap0001.20080929.153102.766064.trc

1028628480 Sep 29 12:32 heapdump.20080929.153102.766064.phd

0 Sep 29 12:32 javacore.20080929.153102.766064.txt

I was searching for any solution in SAP help and notes. I´ve read a lot of notes:

SAP Note 1030279 - Reports with very large result sets-BI Java

SAP Note 1053495 - Settings to get a heapdump with IBM JVM on AIX

SAP Note 1008619 - java.lang.OutOfMemoryError in BEx Web Applications

SAP Note 1127156 - Safety belt: Result set iss too large

SAP Note 723909 - Java VM settings for J2EE

SAP Note 1150242 - Improving performance/memory in the BEX Analyzer

SAP Note 950602 - Performance problems when you start a query in Java Web

SAP Note 1021517 - NW 2004s BI Web memory optimization for large analysis item

SAP Note 1044330 - Java parameterization for BI systems

SAP Note 1025307 - Composite note for NW2004s performance: Reporting

But still not having found an answer to solve this problem.

In note 1030279 there is written:

“We will provide an optimization of the memory requirement in the next Support Package Stack. With this optimization, you can display a report as "stateless", so that the system can then immediately release the memory that is required to set up the result set.”

I´m using Support Stack 15 for ABAP and Java, but I don´t have more information about this problem or stateless function in another note. And I don´t know how can I use this STATELESS function in BI.

Anobody have any idea to solve this problem?

Thanks a lot,

Carlos

[Former Member · Accepted solution]

Hi,

Heap dumps are generated when there is an inmbalance in Java VM parameterization..

Also please remove the parameter "-XX:+HeapDumpOnOutOfMemoryError " in Config tool, so that heap dumps will not generated and fill up the disk space..

My advise is to send the heap dumps to SAP for recommendations.. Meanwhile check with SAP notes for Java VM recommendations..

Regards

Thilip Kumar

Edited by: Thilip Kumar on Sep 30, 2008 5:58 PM

[Former Member]

Hi,

use this note for Java VM setting in configtool. Note 723909 (which u have already checked), copy the logfiles.

Edited by: JITENDRA SINGH on Sep 30, 2008 2:39 PM