Description: Working with Database: a Report can be defined and designed as usual. But no execution of the designed report ist possible. Only an error message appears as you see it below under "Actual result" No report is shown. The report has been defined thats possible, but then it comes out with the above message only. my Version: Version: 7.2.2.2 / LibreOffice Community Build ID: 20(Build:2) CPU threads: 8; OS: Linux 5.14; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded Steps to Reproduce: 1.Setup a database for mysql mariadb or as table-related database 2.create a report with some field 3.execute the report then result: error message see below Actual Results: Error: [jni_uno bridge error] UNO calling Java method execute: non-UNO exception occurred: java.lang.NoClassDefFoundError: org/apache/commons/logging/LogFactory java stack trace: java.lang.NoClassDefFoundError: org/apache/commons/logging/LogFactory at org.pentaho.reporting.libraries.base.boot.AbstractBoot.<clinit>(AbstractBoot.java:55) at org.libreoffice.report.pentaho.PentahoReportEngine.<init>(PentahoReportEngine.java:34) at org.libreoffice.report.pentaho.SOReportJobFactory$_SOReportJobFactory.createReportJob(SOReportJobFactory.java:352) at org.libreoffice.report.pentaho.SOReportJobFactory$_SOReportJobFactory.execute(SOReportJobFactory.java:236) Caused by: java.lang.ClassNotFoundException: org.apache.commons.logging.LogFactory at java.base/java.net.URLClassLoader.findClass(URLClassLoader.java:435) at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:589) at java.base/java.net.FactoryURLClassLoader.loadClass(URLClassLoader.java:855) at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:522) ... 4 more /home/abuild/rpmbuild/BUILD/libreoffice-7.2.2.2/bridges/source/jni_uno/jni_uno2java.cxx:785 After resetted user account exactly the same error-message No report is shown. The report can be defined - that's possible, but then it comes up with the above eror-message only. Expected Results: A designed and well formatted report is wanted according the database data. Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: my version is: Version: 7.2.2.2 / LibreOffice Community Build ID: 20(Build:2) CPU threads: 8; OS: Linux 5.14; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded doesnt matter wether reportbuilder.oxt is used. question: no other reportbuilder can't be found isn't there a specific extension any more ? Is it a buildtin report designer ? My Version is running on "opensuse tumblweed" latest update
On which Linux distrib are you? How did you install 7.2.2?
Also which database type do you use? embedded HSQLDB, Mysql, other? Would it be possible you attach an example file?
Created attachment 175866 [details] Database Testfiles Hello Julien Nabet The .odb is hereattached format as table, dbase and HSQLDB. With Mariadb it is the same bad result. Within each odb file I just created a little report for some fields: Author and identifier ..... No report is printed or executed
Comment on attachment 175866 [details] Database Testfiles Hello Julien Nabet very simply I use from my configuration files: ../.config/libreoffice/4/user/database/ which was automatically set with first opening of libreoffice. This is a dbase database as example. Result is same as with other formats mysql, tablefiles, mariadb or other dbase. The .odb is hereattached format table, dbase and HSQLDB. With Mariadb it is the same bad result. I just set a little report for arbitrary fields: Author and identifier ..... No report is printed or executed
(In reply to Julien Nabet from comment #1) > On which Linux distrib are you? > How did you install 7.2.2? this comes from opensuse updated system by #/: zypper dup via ftp.gwdg.de/pob/opensuse ....
(In reply to Julien Nabet from comment #1) > On which Linux distrib are you? > How did you install 7.2.2? installed via ftp.gwdg.de/pub/opensuse/..... by command: zypper dup
On pc Debian x86-64 with LO Debian testing package 7.2.2, I don't reproduce this. I mean, I could open biblio2HSQLDB.odb for example and execute the report. I don't know at all how Zypper works and never used Suse or OpenSuse. Did you check Java was installed and it corresponded 32/64 bits (I mean LO 32 bits needs Java 32 bits, LO 64 bits needs Java 64 bits)? What Java do you use, what's its version and 32/64 bits? Also, on Debian there's a package: libreoffice-java-common I don't know if it's the case for OpenSuse. Robert: I don't remember what distrib you use but thought you may have some opinion here.
Have tested this on OpenSuSE 15.2 64bit rpm Linux. Could execute the report of every database in the attachment with Version: 7.1.4.2 / LibreOffice Community Build ID: 10(Build:2) CPU threads: 6; OS: Linux 5.3; UI render: default; VCL: kf5 Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded and also with Version: 7.2.2.2 / LibreOffice Community Build ID: 02b2acce88a210515b4a5bb2e46cbfb63fe97d56 CPU threads: 6; OS: Linux 5.3; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded You have installed the version SuSE Tumblweed has created. Please test it with a version directly from LO. I have installed many versions parallel as a normal user - not as root - to test the behavior for bugs. File the bug to SuSE, because it seems to be a special behavior of the version SuSE has build.
(In reply to Robert Großkopf from comment #8) > Have tested this on OpenSuSE 15.2 64bit rpm Linux. > Could execute the report of every database in the attachment with > > Version: 7.1.4.2 / LibreOffice Community > Build ID: 10(Build:2) > CPU threads: 6; OS: Linux 5.3; UI render: default; VCL: kf5 > Locale: de-DE (de_DE.UTF-8); UI: de-DE > Calc: threaded > > and also with > Version: 7.2.2.2 / LibreOffice Community > Build ID: 02b2acce88a210515b4a5bb2e46cbfb63fe97d56 > CPU threads: 6; OS: Linux 5.3; UI render: default; VCL: kf5 (cairo+xcb) > Locale: de-DE (de_DE.UTF-8); UI: de-DE > Calc: threaded > > You have installed the version SuSE Tumblweed has created. Please test it > with a version directly from LO. I have installed many versions parallel as > a normal user - not as root - to test the behavior for bugs. > > File the bug to SuSE, because it seems to be a special behavior of the > version SuSE has build. Thanks Robert, I will file the bug to SuSE. This Version works fine: Version: 7.1.2.2 / LibreOffice Community Build ID: 8a45595d069ef5570103caea1b71cc9d82b2aae4 CPU threads: 8; OS: Linux 5.14; UI render: default; VCL: kf5 Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded and Version: 7.2.2.2 / LibreOffice Community Build ID: 02b2acce88a210515b4a5bb2e46cbfb63fe97d56 CPU threads: 8; OS: Linux 5.14; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded works fine as well. I did installation with several version in /opt . All are usable - only the one from SuSErepo http://download.opensuse.org/tumbleweed or http://download.opensuse.org/update/tumbleweed/ has this bug.
Per comment 9, NOTOURBUG.
*** Bug 148841 has been marked as a duplicate of this bug. ***
*** Bug 158854 has been marked as a duplicate of this bug. ***
All affected: please see if the workaround in https://bugzilla.opensuse.org/show_bug.cgi?id=1195634#c11 works for you.