Ad-hoc Reporting - Java 100%

[analufaria]

Hello People,

When I create a ad-hoc report with a lot of data, Java is 100% loaded, therefore no data is returned.

Would anybody know as solving that problem?

Thank's in advanced!

Ana Lúcia Faria

[sbarkdull]

Can you be more specific about what you mean when you say "create a report"?

Can you be more specific about what you mean when you say "java is 100% loaded"?

Can you be more specific about what you mean when you say "a lot of data"? Do you mean there are a lot of columns in your report? Or that your query returns a lot of rows? Something else?

[analufaria]

Hi Steven,

Can you be more specific about what you mean when you say "create a report"?

Really, this happen when I run my ad-hoc report. The report has only 3 columns, but it has about 200.000 lines in the database.

Can you be more specific about what you mean when you say "java is 100% loaded"?

On the windows task manager the process java.exe reaches 100% of CPU.

Can you be more specific about what you mean when you say "a lot of data"? Do you mean there are a lot of columns in your report? Or that your query returns a lot of rows? Something else?
Yes. I have a lot of data (lines) in my database and the WARQ never returns.

Help me, please...
Thank's in advanced!

[sbarkdull]

Can you tell me which version of the Pentaho BI platform you are using? Prior to the 1.6 GA release, there was a known defect in the reporting engine that resulted in behavior similar to what you are experiencing (ie reports with a lot of data take a very, very long time to run). This release was made available about the middle of Sept 07.

If the release you are using is older than this, you will likely see a significant performance improvement by upgrading to the latest 1.6 GA release.

Let me know if that does/doesn't address your problem.

[MattCasters]

Also, try giving your java process (JBoss) a bit more memory. If the "java" process is pegged at 100%, a near Out-of-memory situation might be occurring.

Matt

[analufaria]

Hi Steven / Matt

Also, try giving your java process (JBoss) a bit more memory. If the "java" process is pegged at 100%, a near Out-of-memory situation might be occurring.

I didn't urderstand that topic, what did you mean?
How can I give a bit more memory to Java?

Can you tell me which version of the Pentaho BI platform you
are using?

I use Pentaho BI Plataform 1.6 GA release


Thank's you very much for your help.
Do you have what the problem?

Ana Lúcia Faria

[MattCasters]

in your Pre-Configured Installation (PCI) go do directory jboss/bin
There is a file called run.conf

Change the -Xmx parameter in the JAVA_OPTS line to something higher. Give it 1GB or more and try again.

On a higher level please remember that reports that need that much memory are not providing any information anyway.

All the best,
Matt

[analufaria]

Hi Matt,

Thank you very much for your answer, but I downloaded Pentaho Plataform 1.7.0 and in run.config file is Xmx512m, too.
That last version works well, and I would like to use 1.6

Any idea?

Ana Lúcia Faria

[Taqua]

This can be caused by the 1.6 platform's report engine. The 1.6 GA ships with 0.8.9-RC-6 of the Report-Engine; while 1.7 ships with 0.8.9-GA of the engine.

Version 1.7.0 is a bugfix release, it does not contain new features, just new bug-fixes. It is still under development, and will be officially released in a couple of weeks. So yes, you can use the 1.6GA by upgrading the report-engine jars, but then you would miss a lot of fixes in the other parts of the platform. Go with 1.7.0, it is safer.

[analufaria]

Hi Taqua,

Thank you very much for your answer.

After I am going to use the new version.

Do you know when Pentaho Plataform 1.7 GA will be officially released?

Thank's again!

Ana Lúcia Faria