Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

Andreas Säger wrote:
> Am 26.05.2012 22:13, Girvin R. Herr wrote:
> > >
> > Andreas,
> > Yes! Plus the "com.mysql.jdbc.Driver" class and the "MySQL (JDBC)"
> > connection type option.
> > And I am using the "MySQL-connector-java-5.0.7-bin.jar" in the class
> > path and the MySQL 5.0.67 server.
> > Sun (Oracle) Java version 1.6.0_30
> > All test okay, of course.
> > Thanks.
> > Girvin
>
> Install Java 1.6.0_22 or LibreOffice 3.5.x and things will run with 
> normal speed.
Andreas,
Here is some more data on the subject.  I opened LO in a shell so I 
could catch any LO errors and then started my report build.  The 
following enclosure was then displayed in the shell.
Note that the first 2 errors regarding library version information come 
up when I invoke LO, before I open ORB.  My research informed me that 
these version errors are not fatal, despite the "required" tag. They are 
just a minor mismatch between my libraries and the ones compiled with 
LO.  However, the "pentaho" errors, whatever pentaho is,  may be 
significant, especially the Null Pointer errors.

----------------------------------------- Start of enclosure
501:$libreoffice3.5
/opt/libreoffice3.5/program/../ure-link/bin/javaldx: 
/usr/lib/libxml2.so.2: no version information available (required by 
/opt/libreoffice3.5/ure/bin/../lib/libjvmfwk.so.3)
/opt/libreoffice3.5/program/soffice.bin: /usr/lib/libpng12.so.0: no 
version information available (required by 
/opt/libreoffice3.5/program/libcairo.so.2)
May 27, 2012 12:36:40 PM 
org.pentaho.reporting.libraries.base.boot.AbstractBoot start
INFO: LibSerializer 1.1.6.10682 started.
May 27, 2012 12:36:40 PM 
org.pentaho.reporting.libraries.base.boot.AbstractBoot start
INFO: LibBase 1.1.6.10682 started.
May 27, 2012 12:36:41 PM 
org.pentaho.reporting.libraries.base.boot.AbstractBoot start
INFO: LibLoader 1.1.6.10682 started.
May 27, 2012 12:36:41 PM 
org.pentaho.reporting.libraries.base.boot.AbstractBoot start
INFO: LibRepository 1.1.6.10682 started.
May 27, 2012 12:36:41 PM 
org.pentaho.reporting.libraries.base.boot.AbstractBoot start
INFO: LibFonts 1.1.6.10682 started.
May 27, 2012 12:36:41 PM 
org.pentaho.reporting.libraries.base.boot.AbstractBoot start
INFO: LibLayout null started.
May 27, 2012 12:36:41 PM 
org.pentaho.reporting.libraries.base.boot.AbstractBoot start
INFO: LibFormula 1.1.7.10682 started.
May 27, 2012 12:36:41 PM 
org.pentaho.reporting.libraries.base.boot.AbstractBoot start
INFO: LibXML 1.1.7.10682 started.
May 27, 2012 12:36:41 PM 
org.pentaho.reporting.libraries.base.boot.PackageManager loadModule
WARNING: Exception while loading module: 
org.pentaho.reporting.libraries.base.boot.DefaultModuleInfo={ModuleClass=org.jfree.report.modules.gui.swing.common.SwingCommonModule}
java.lang.NullPointerException
       at 
org.pentaho.reporting.libraries.base.boot.PackageManager.containsModule(PackageManager.java:369)
       at 
org.pentaho.reporting.libraries.base.boot.PackageManager.loadModule(PackageManager.java:436)
       at 
org.pentaho.reporting.libraries.base.boot.PackageManager.addModule(PackageManager.java:330)
       at 
org.pentaho.reporting.libraries.base.boot.PackageManager.load(PackageManager.java:199)
       at org.jfree.report.JFreeReportBoot.performBoot(Unknown Source)
       at 
org.pentaho.reporting.libraries.base.boot.AbstractBoot.start(AbstractBoot.java:197)
       at 
com.sun.star.report.pentaho.PentahoReportEngine.<init>(PentahoReportEngine.java:45)
       at 
com.sun.star.report.pentaho.SOReportJobFactory$_SOReportJobFactory.createReportJob(SOReportJobFactory.java:328)
       at 
com.sun.star.report.pentaho.SOReportJobFactory$_SOReportJobFactory.execute(SOReportJobFactory.java:222)
May 27, 2012 12:36:41 PM 
org.pentaho.reporting.libraries.base.boot.PackageManager loadModule
WARNING: Exception while loading module: 
org.pentaho.reporting.libraries.base.boot.DefaultModuleInfo={ModuleClass=org.jfree.report.modules.gui.swing.html.SwingHtmlModule}
java.lang.NullPointerException
       at 
org.pentaho.reporting.libraries.base.boot.PackageManager.containsModule(PackageManager.java:369)
       at 
org.pentaho.reporting.libraries.base.boot.PackageManager.loadModule(PackageManager.java:436)
       at 
org.pentaho.reporting.libraries.base.boot.PackageManager.addModule(PackageManager.java:330)
       at 
org.pentaho.reporting.libraries.base.boot.PackageManager.load(PackageManager.java:199)
       at org.jfree.report.JFreeReportBoot.performBoot(Unknown Source)
       at 
org.pentaho.reporting.libraries.base.boot.AbstractBoot.start(AbstractBoot.java:197)
       at 
com.sun.star.report.pentaho.PentahoReportEngine.<init>(PentahoReportEngine.java:45)
       at 
com.sun.star.report.pentaho.SOReportJobFactory$_SOReportJobFactory.createReportJob(SOReportJobFactory.java:328)
       at 
com.sun.star.report.pentaho.SOReportJobFactory$_SOReportJobFactory.execute(SOReportJobFactory.java:222)
May 27, 2012 12:36:41 PM 
org.pentaho.reporting.libraries.base.boot.PackageManager loadModule
WARNING: Exception while loading module: 
org.pentaho.reporting.libraries.base.boot.DefaultModuleInfo={ModuleClass=org.jfree.report.modules.gui.swing.pdf.SwingPdfModule}
java.lang.NullPointerException
       at 
org.pentaho.reporting.libraries.base.boot.PackageManager.containsModule(PackageManager.java:369)
       at 
org.pentaho.reporting.libraries.base.boot.PackageManager.loadModule(PackageManager.java:436)
       at 
org.pentaho.reporting.libraries.base.boot.PackageManager.addModule(PackageManager.java:330)
       at 
org.pentaho.reporting.libraries.base.boot.PackageManager.load(PackageManager.java:199)
       at org.jfree.report.JFreeReportBoot.performBoot(Unknown Source)
       at 
org.pentaho.reporting.libraries.base.boot.AbstractBoot.start(AbstractBoot.java:197)
       at 
com.sun.star.report.pentaho.PentahoReportEngine.<init>(PentahoReportEngine.java:45)
       at 
com.sun.star.report.pentaho.SOReportJobFactory$_SOReportJobFactory.createReportJob(SOReportJobFactory.java:328)
       at 
com.sun.star.report.pentaho.SOReportJobFactory$_SOReportJobFactory.execute(SOReportJobFactory.java:222)
May 27, 2012 12:36:41 PM 
org.pentaho.reporting.libraries.base.boot.PackageManager loadModule
WARNING: Exception while loading module: 
org.pentaho.reporting.libraries.base.boot.DefaultModuleInfo={ModuleClass=org.jfree.report.modules.gui.swing.preview.SwingPreviewModule}
java.lang.NullPointerException
       at 
org.pentaho.reporting.libraries.base.boot.PackageManager.containsModule(PackageManager.java:369)
       at 
org.pentaho.reporting.libraries.base.boot.PackageManager.loadModule(PackageManager.java:436)
       at 
org.pentaho.reporting.libraries.base.boot.PackageManager.addModule(PackageManager.java:330)
       at 
org.pentaho.reporting.libraries.base.boot.PackageManager.load(PackageManager.java:199)
       at org.jfree.report.JFreeReportBoot.performBoot(Unknown Source)
       at 
org.pentaho.reporting.libraries.base.boot.AbstractBoot.start(AbstractBoot.java:197)
       at 
com.sun.star.report.pentaho.PentahoReportEngine.<init>(PentahoReportEngine.java:45)
       at 
com.sun.star.report.pentaho.SOReportJobFactory$_SOReportJobFactory.createReportJob(SOReportJobFactory.java:328)
       at 
com.sun.star.report.pentaho.SOReportJobFactory$_SOReportJobFactory.execute(SOReportJobFactory.java:222)
May 27, 2012 12:36:41 PM 
org.pentaho.reporting.libraries.base.boot.PackageManager loadModule
WARNING: Exception while loading module: 
org.pentaho.reporting.libraries.base.boot.DefaultModuleInfo={ModuleClass=org.jfree.report.modules.gui.swing.printing.SwingPrintingModule}
java.lang.NullPointerException
       at 
org.pentaho.reporting.libraries.base.boot.PackageManager.containsModule(PackageManager.java:369)
       at 
org.pentaho.reporting.libraries.base.boot.PackageManager.loadModule(PackageManager.java:436)
       at 
org.pentaho.reporting.libraries.base.boot.PackageManager.addModule(PackageManager.java:330)
       at 
org.pentaho.reporting.libraries.base.boot.PackageManager.load(PackageManager.java:199)
       at org.jfree.report.JFreeReportBoot.performBoot(Unknown Source)
       at 
org.pentaho.reporting.libraries.base.boot.AbstractBoot.start(AbstractBoot.java:197)
       at 
com.sun.star.report.pentaho.PentahoReportEngine.<init>(PentahoReportEngine.java:45)
       at 
com.sun.star.report.pentaho.SOReportJobFactory$_SOReportJobFactory.createReportJob(SOReportJobFactory.java:328)
       at 
com.sun.star.report.pentaho.SOReportJobFactory$_SOReportJobFactory.execute(SOReportJobFactory.java:222)
May 27, 2012 12:36:41 PM 
org.pentaho.reporting.libraries.base.boot.AbstractBoot start
INFO: Pentaho Reporting Flow-Engine null started.

----------------------------------------  End of enclosure
Null pointers are _*not*_ a good sign.
No further messages were output and I terminated the report generation 
process before it completed.
I would like to resolve this ORB problem, since the Calc solution has a 
couple problems with it.  Mainly, I remembered last night that several 
of my reports have so much data in each record that they are printed 
with two or more lines of text in the report, which I don't believe can 
be done neatly in Calc.
Hope this helps resolve this problem.
Girvin


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted