Date: prev next · Thread: first prev next last
2017 Archives by date, by thread · List index


Peter,

First, I have both Apache OpenOffice (AOO) and LibreOffice (LO) installed on my Slackware Linux computer. I mostly use AOO, but when I do my database reports, I open up LO to process them with the LO Base Report Builder. I do this because AOO does not have a stable Report Builder (see below) and LO does. So far, in more than a decade of use, I have not had any document compatibility problems between the two apps. We can thank the Open Document people and how strongly the app writers conform to the Open Document standards for that.

In my experience, the database support file (the .odb file) that contains all the app support stuff and gui definitions for the database is compatible between the two apps. So, there should be nothing to do in your Base gui to switch. Actually, I copied my .odb file from AOO to use with LO when I installed LO and I keep them both in separate sub-directories, just to be sure either does not get corrupted from the other app. I makes a good backup too.

That said, I have no experience with the LO or AOO internal database server (aka "engine", "back end", etc.). I use the external Mariadb (MySQL) server for my databases, so switching the clients (AOO and LO) is not a problem for me. If you are using the internal database server, I would strongly suggest saving your database first and then opening it on AOO to see if it works. You can always restore the database with your saved database if things go terribly wrong.

Keep in mind that OpenOffice does not have a Report Builder bundled in like LibreOffice does. There is an old extension (Oracle Report Builder) available that is advertised as compatible up to AOO 3.x, but is claimed by some to still work with the latest AOO 4.x version. I have not tried it yet and even then, it may not be as stable or up-to-date as the one bundled in with LO.
https://extensions.openoffice.org/en/project/oracle-report-builder

HTH. Good luck.
Girvin


On 11/28/2017 12:31 PM, Peter wrote:
Definitly a hard crash. When restarted it goes into a recovery process. If I install Open Office will it work with the Lire Base data bases or would I need to export the data and recreate new data bases?

Peter

On 29/11/17 06:47, Girvin Herr wrote:
Peter,

What indication do you have that LO crashes?
Does it lock up or disappear (a hard crash)?

If the former, LO may just be taking a long time to process something. Patience is a virtue. I have some reports that search on database string fields that are quite slow to process the report. I can go out and have a cup of coffee and maybe it will be done when I return.

If the latter, there is a known security fix problem with Linux kernels later than about 4.4.75 and Java. This problem affected LibreOffice, but not OpenOffice, from my experience. There is a fix, but it is technical, regarding stack frame gap size settings. The fix is to add a kernel boot parameter to your booter (Lilo or Grub or whatever). If you updated your *buntu since LO last worked, this may be your problem.

HTH.
Girvin Herr



On 11/27/2017 09:25 PM, Peter wrote:
Base is installed and for my financial database the only problem I have is reports. I followed the advice and installed the packages. This made no difference. When I open the data base and select a previously defined report the data bases crashes. If I use the report creation facility when I select the report wizard again the data base crashes.

Does base log these failures and if so where can I look at it?

My fishing data base opens but I cannot open fofms , tables , queries etc.

This problem with Base has occurred in the last 12 months.

Any suggestions on what to do next will be gratefully received.


Peter




On 28/11/17 09:20, Keith Bates wrote:
I use Ubuntu 17.04 also, including the Libreoffice packages installed directly from Ubuntu. The default install excludes Base, and if you can't open a database, it seems like you don't have Base installed. sudo apt install libreoffice-base should fix that,

For reports the packages you need are libreoffice-report-builder and libreoffice-report-builder-bin. Use sudo apt install libreoffice-report-builder* and they should install.


Keith


On 28/11/17 08:45, Peter wrote:
I reinstalled Libre Office Base from the Ubuntu repository. I assumed that this wouls automatically install all necessary packages. a=There is nothing that I can find in the__Ubuntu Software Repository that appears to relate to reports for LibreBase. How can i find out what packages I have installed and what packages are required forreports to work. I have an old data base which has not been uses since January 2015 which I tried to open today. This will no longer open for any thing , no forms or views or tables can be opened.

Peter

On 28/11/17 04:50, Robert Großkopf wrote:
Hi Peter,

Libre Base 1:5.1.6~rc2-0ubuntu1~xenial2

Ubuntu 16.4

When I first found the problem I removed LibreBase and reinstalled it
but the problem with reportsremained the  same.
This is a special Ubuntu-version of LO. Have a look into your
packagemanager. Did you install all packages for the
libreoffice-report-builder? Have heard there isn't only one package,
which should be installed for reports with the Ubuntu-version of LO.

Regards

Robert











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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.