Ask Your Question

Unable to open database after a restore

asked 2019-06-14 17:01:17 +0200

Gary Campbell gravatar image

updated 2020-08-07 13:57:49 +0200

Alex Kemp gravatar image

Have used Base with a lot of success for about a year. Ran into a problem with other parts of OS and had to recover with DJ Backup.

Everything looks good on the first two screen. "Open a recent database file" sees the database file. tapping finish brings up the first screen Database and Tasks/Forms . Also the Database column has Forms highlighted and Forms shows the forms that were created - the list of forms is accurate.

But, if I try to do anything - like click on Tables get the following message or other items. The connection to the data source "CUSJ-Database" could not be established.

Running : Ubuntu 19.4, mem. 7.7 Gib, intel core I3, Gnome 3.32.1,OS type 64-bit, disk SSC 240 GB

Thanks Gary Thanks Gary

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2019-06-25 03:52:02 +0200

Gary Campbell gravatar image

Solved. Seems like Ubuntu 19.04 broke Base. Solution: Installed Ubuntu 18.04.2 LTS, installed Base with sudo apt-get install libreoffice-base

Likely some part of JAVA actually broken on 19.04 so HSQLDB database could not be opened.

Thank you for helping me.

edit flag offensive delete link more

answered 2019-06-14 17:37:34 +0200

Ratslinger gravatar image

@Gary Campbell,

You have not specified what type of database (and if other than embedded DB the connection type) you are using or the specific LO version being used.

Depending upon that, you may want to check the database connection settings -> Edit->Database both Properties and Connection Type. Also check, especially if not using an embedded DB, the settings in Tools->Options under LibreOffice->Advanced for Java and connectors.

edit flag offensive delete link more


I am using an embedded LO DB - no server. "...connection settings -> Edit->Database" both 'properties' and 'connections' are greyed out. "Advanced Settings" are all ticked off.
" Tools->Options under LibreOffice->Advanced for Java and connectors." Oracle Corporation 1.8.0_211, location /usr/lib/jvm/jre1.8.0_211.
LibreOffice Base >Connections Connection pooling enabled yes 60 ~ sdbc.JDBCDriver yes 60 ~ sdbc.dbase.ODriver yes 60 ~ sdbc.firebird.ODriver yes 120 The above, I have clicked on Apply OK then left the screen. On returning to the screen, ODBCDriver is always selected. LibreOffice Base > Databases shows Registered Database Bibliography ~/4/usr/database/biblio.odb is highlighted even when I have selected: CUSJ-Database /home/gary/Documents/Unitarian/CUSJ/Database-project/CUSJ-Database.odb Gary

Gary Campbell gravatar imageGary Campbell ( 2019-06-15 20:27:29 +0200 )edit

Still don't know what DB you are using. Embedded can be either Firebird or HSQLDB - displayed at bottom center of Base screen.

In Tools->Options:

  • Under LibreOfice->Advanced, Use a Java runtime environment should be have checkmark in box. Also Oracle (JRE) should be selected (dot in circle to left of "Oracle")

  • Under LibreOffice Base->Connections remove the checkmark in Connection pooling enabled.

  • Save then close ALL open LO programs running. Then restart Base & test.

If still a problem will need a sample .odb Base file without personal/confidential information.

Ratslinger gravatar imageRatslinger ( 2019-06-15 21:29:45 +0200 )edit

Still a problem

Embedded is HSQLDB Tools->Options>LibreOfice->Advanced . Use a Java runtime environment is checkmarked in box and Oracle (JRE) is selected (dot in circle to left of "Oracle") • Under LibreOffice Base->Connections removed the checkmark in Connection pooling enabled. • Did save All then closed ALL open LO programs running. Then restarted Base & test. Had the same result How do I send you the database file without the table contents? The database has member Name and Address information as well as small donations and other related data for a social justice organization. Base /home/gary/Documents/Unitarian/CUSJ/Database-project/CUSJ-database/CUSJ-Database.odb 133,175 kb Thanks for your help

Gary Campbell gravatar imageGary Campbell ( 2019-06-15 22:33:38 +0200 )edit

Tried to created a database with HSQLDB, error appeared when I tried to create a table. Then created a database with Firebird Embedded. Was able to set up a table with three records. Saved and closed the database. Was able to restart the test database and open the table. Does that mean the problematic CUSJ-Databse should be a Firebird Embedded instead of a HSQLDB embedded? How do I change that?

Gary Campbell gravatar imageGary Campbell ( 2019-06-15 22:59:53 +0200 )edit

A guess here is that you have a problem with the Java installation. Firebird ran and does not need Java. HSQLDB does need Java. You can run Firebird without Java but you lose other functions such as Wizards and Report Builder.

You can try re-installing Oracle JRE or use OpenJDK (have used both on Ubuntu 18.04). You can have multiple versions installed simultaneously. Remember that 64-bit LO needs 64-bit Java. Also, verify then that this is selected in Advanced options of Options.

Ratslinger gravatar imageRatslinger ( 2019-06-15 23:16:31 +0200 )edit

Sure you are right but has not worked with me.
In tools>option>Libreoffice>Advanced have tried with Oracle Corporation 1.8.0_211 Location: /usr/lib/jvm/jre1.8.0_211

Ubuntu 11.0.3 Location :/usr/lib/jvm/java-11-openjdk-amd64 Also added Location :/usr/lib/jvm/java-1.11-openjdk-amd64 but it shows up as Location :/usr/lib/jvm/java-11-openjdk-amd64 in >Advanced

Oracle Corporation 1.8.0_211 Location: /usr/lib/jvm/jre1.8.0_211 was extracted from /usr/lib/jvm/jre-8u211-linux-x64-.tar.gz Tried and retried but none of them work for me

removed and re-installed Base with sudo before some of the trials Tried with Firebird but it finds my table names too long, so got nowhere with that. Gary

Gary Campbell gravatar imageGary Campbell ( 2019-06-16 03:03:02 +0200 )edit

Only thing I have left - try to reset user profile (not done during re-installation). See -> LibreOffice user profile.

If still a problem may want to file a bug report -> Bugzilla.

Ratslinger gravatar imageRatslinger ( 2019-06-16 03:53:50 +0200 )edit

Hi Ratslinger, I will follow your suggestion later today - too much to do today. And first need to take a large backup. Thanks Gary

Gary Campbell gravatar imageGary Campbell ( 2019-06-16 14:49:18 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-06-14 17:01:17 +0200

Seen: 251 times

Last updated: Jun 25 '19