Very large HEAPDUMP files are generated when executing BI Web reports NW7.0
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,