Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question