BASE, error: The data content could not be loaded

asked 2019-11-22 08:40:38 +0100

ikopanas gravatar image

updated 2019-11-22 11:40:43 +0100

Well I use LibreOffice 6.3.3.2 (x86) BASE to connect through JDBC with MySQL (com.mysql.jdbc.Driver). Created a new mySQL database with some tables and then some queries stored to BASE which are running without any problems so far.

Then I have created one more query also stored to BASE called:

qOrderServicesByCustomer

When opening gives the results OK which means its correct. But when I create and run a new query based on the initial one

e.g SELECT * from qOrderServicesByCustomer

then I get the error: Unable to Load Data Content

Any ideas out there? Also I wonder keeping queries to BASE is a good practise? Is it better to save them to MySQL as stored procedures?

edit retag flag offensive close merge delete

Comments

Hello,

If in fact you are running 32-bit that may be where the problem lies. Only have 64-bit in which all seems to work without a problem:

Linux Ubuntu 18.04
LO v6.3.3.2
MySQL v5.7.28
JDBC    MySQL(JDBC)

Please verify you are in fact using 32-bit & also please state OS and MySQL version.

Ratslinger gravatar imageRatslinger ( 2019-11-22 18:24:30 +0100 )edit

At first I want really to thank you Ratslinger for your time and advice...

Well I was really using the 32bit LO. So I uninstall and reinstall the 64 bit version. Here is my configuration now: Client Side: Operating System Windows 10-64bit RAM 4GB LibreOffice Edition: 6.3.3.2 (x64) JRE 1.8.0_231 MySQL Connector Java 8.0.18 I also use a static IP via NordVPN to connect to server Server Side: Server: Localhost via UNIX socket Server Type: MariaDB Server Version: 10.2.27-MariaDB-cll-lve - MariaDB Server

Now my system became unstable and crashes all the time, when working with the LO and the MySQL database... and still getting the message

I wonder what causes the problem... In my opinion could be a memory problem, anyway still getting the message: Unable to Load Data Content and an SQLState: HY000 error during I run some complicated queries that ...(more)

ikopanas gravatar imageikopanas ( 2019-11-25 20:58:00 +0100 )edit

@ikopanas,

Unfortunately abandoned Windows years ago for Linux and don't have a testing setup for remote DB.

Have tested remote MySQL (not MariaDB) in past and had little problem. This worked with JDBC 5.x connector and also an older native connector not available in current LO version. Had some problems with JDBC 8.x connector but don't recall if that was for the local or remote connection or both.

Have not experienced the problems you note and have used LO for years now. You may want to try local creation of Base file or even Writer & Calc to see if crashes continue. If not it may the connector or connection string etc.

Other than that it appears to be more of a hands on type of problem. Eliminate items one at a time.

Ratslinger gravatar imageRatslinger ( 2019-11-25 22:52:53 +0100 )edit