Report in Base not executed

users
#1

My configuration is Libre-Office Version: 4.3.2.2.0+
Build ID: 430m0(Build:2) on Gnome 3.14.1 under Opensuse 13.2.

I had a simple MySql database running perfectly well under OpenSuse 13.1
using Libre-Office Base as front end. Now when trying to execute my
report in the new configuration, I get the following error:

Information: "An exception of type
com.sun.star.loader.CannotActivateFactoryException was caught."

Error: "Can not activate the factory for
org.libreoffice.report.pentaho.SOReportJobFactory$_SOReportJobFactory
because java.lang.NoClassDefFoundError: Could not initialize class
org.libreoffice.report.pentaho.SOReportJobFactory$_SOReportJobFactory"

Does anyone know what and how I should correct this?

By the way, the title bar of Libre-Office Base report editor window is
showing Spanish text "generador de informes de Oracle" where only
English and German are activated in this configuration

Cheers
Harvey

#2

Sounds similar to this :

https://www.libreoffice.org/bugzilla/show_bug.cgi?id=51278

which was around in the transition to LO 3.6.x

Maybe try resetting your LO user configuration profile ?

Alex

#3

Hi :slight_smile:
Here's a link to help you follow Alex's advice
https://wiki.documentfoundation.org/UserProfile

It often helps fix a wide variety of weird problems. I hope it helps with
this one too! :))
Good luck and regards from
Tom :slight_smile:

#4

What/where is my LO user configuration profile? Do you mean the User
Data in the options?

Cheers
Harvey

#5

Interestingly, however, the report is shown correctly in the 'preview'
window. The error occurs only when actually opening the report.

Cheers
Harvey

#6

I tried that after trying to reset my UserProfile (thanks to Tom Davies' advice).
It seems now a wee bit clearer that the
com.sun.star.comp.loader.JavaLoader is missing.

Harvey

#7

Hi Harvey,

My configuration is Libre-Office Version: 4.3.2.2.0+
Build ID: 430m0(Build:2) on Gnome 3.14.1 under Opensuse 13.2.

Is this the version of LibreOffice provided by the OpenSuse package
management system ? i.e. a version built and provided by the OpenSuse
project ?

Can you try a TDF provided version of LibreOffice instead (from the
LibreOffice download page) or are there no suitable packages ?

Alex

#8

Hi to everyone.

4.3.4.1 windows "msi" installation package behave same way: LibreOffice
_crashes _when a report is opened in base.

Unfortunately, not ALL machines have the problem. My Windows Vista 64bit pc
crashes, an other windows XP 32bit pc don't....
Anyway, that problem have NEVER occured with any other windows OS pc, using
previous LO versions.

Federico Quadri

Alex Thurgood <alex.thurgood@gmail.com> ha scritto:

#9

Yes, this is the version provided under OpenSuse. And I am not too keen
on experimenting with other versions/sources, for the sake of
consistency within my system

Cheers
Harvey

#10

Hi :slight_smile:
Crashing is usually due to some 3rd party Extension or some weird tangle of
settings in the User Profile. Renaming the User Profile is usually fairly
quick and easy, once you've figured it out first time
https://wiki.documentfoundation.org/UserProfile

The 2nd most likely cause has tended to be Java issues. if you are using
the internal back-end on Base or using Accessibility tools such as
screen-readers then there might not be much you can do except to maybe
consider upgrading Java or finding a more stable version of Java. The rest
of us can switch off Java dependence temporarily;
Tools - Options - Advanced
and if LibreOffice grumbles then switch it back on again. Most people find
they can live without Java in LibreOffice and maybe even uninstall it.

Generally it is always best to stick with the distro-specific tweaked
versions of almost all software. Going outside of that often requires
quite a bit of 'proper' linuxy experience and knowledge. It's not usually
a good idea for a point&click user like myself!

However LibreOffice is one of the exceptions. it's very forgiving about
it's dependencies and it's unlikely that something else is depending on a
specific version of LO. It's about the only package i ever install
directly from the upstream site and i have grown quite comfortable doing
so. If it doesn't work out it's fairly easy to remove all the downloaded
official TDF version and then reinstall your own distros version from their
repos but it's unlikely you would need to. The only downside is that you
have to remember to upgrade it yourself. Many of us don't even upgrade
once a year, despite official recommendations, without any noticeable
problems.

It is also possible to install more than 1 version of LibreOffice at a time
to get the best of both worlds
https://wiki.documentfoundation.org/Installing_in_parallel

#11

Tools - Options - Advanced
and if LibreOffice grumbles then switch it back on again. Most people
find they can live without Java in LibreOffice and maybe even
uninstall it.

Indeed LibreOffice grumbles if I switch off Java. As soon as I try to
execute the report it reminds me that jre is not running and do I want
to switch it on. If I switch it on, I get the error message that the
JavaLoader cannot be found, as below:

"SQL Status: S1000"
An error occurred while creating the report.
An exception of type com.sun.star.uno.RuntimeException was caught.

javaloader error - could not find class
com/sun/star/comp/loader/JavaLoader"

Where is this missing class to be found?

Cheers
Harvey

#12

I have submitted a bug to bugzilla for this after being advised to by
'wolfi32'.

Cheers
Harvey

#13

Hi :slight_smile:
Nicely done! :slight_smile:

Errr, have you been able to temporarily work-around by going back to an
older version of LibreOffice or have you had a chance to test-drive a newer
version, maybe as a parallel install? I dunno if that might help but it
might be worth a try!
Regards from
Tom :slight_smile:

#14

I might do that if it becomes urgent for me. I am not quite sure if it
is an LO problem or a problem with the OpenSuse packaging and I haven't
(yet) the need to start experimenting.

Cheers
Harvey