[Solved] Database unable to open

Discuss the database features

Re: [Solved] Database unable to open

Postby Sliderule » Tue Jan 16, 2018 4:19 pm

BarneyinOZ

I just sent you a PM ( Private Message ).

Sliderule
User avatar
Sliderule
Volunteer
 
Posts: 1133
Joined: Thu Nov 29, 2007 9:46 am

Re: [Solved] Database unable to open

Postby Hendrie » Thu Jan 18, 2018 5:07 pm

Hi -just discovered this forum. I hope you can help.

I have occasion to use an OpenOffice database just a few times a year. Unfortunately when I used it today there was a problem.

The OpenOffice database refused to save and when I restarted the computer the database could not be loaded. Error message said something about a connection not being able to be made.

I discovered that I had SysInfo Tool v1.0 on my computer (bought some time ago) so used it (apparently successfully) to repair the database.

Now when I try to load the repaired database it tells me that I should be User: SA

Any suggestions most welcome.

Hendrie
OpenOffice 4.1.5 on Windows 10
Hendrie
 
Posts: 3
Joined: Thu Jan 18, 2018 4:56 pm

Re: [Solved] Database unable to open

Postby Hendrie » Thu Jan 18, 2018 5:13 pm

With regard to previous post the errors are reported as :

SQL Status: S1000 Error code: -37 User not found: SA
OpenOffice 4.1.5 on Windows 10
Hendrie
 
Posts: 3
Joined: Thu Jan 18, 2018 4:56 pm

Re: [Solved] Database unable to open

Postby Hendrie » Thu Jan 18, 2018 10:46 pm

Fingers crossed I now seem to have recovered the data from the last backup file that wasn't O kb in length.
OpenOffice 4.1.5 on Windows 10
Hendrie
 
Posts: 3
Joined: Thu Jan 18, 2018 4:56 pm

Re: [Solved] Database unable to open

Postby vayaplaya » Mon Feb 19, 2018 4:53 pm

I cannot open my database, even though it has been opened and closed several times this past week. Today it asks for Filter Options when opening the file. If the Base file is opened using OpenOffice Writer, it consists of 7,600 pages with only readable English in the last 7 pages (beginning with mimetypePK and database/logPK). The .obd.lck file was not deleted when I closed the database the last time and then quit Apache OpenOffice. On all occasions previously when power has been disrupted, Apache OpenOffice was able to recover the file on start-up.

The last update for macOS (High Sierra 10.13.3) was on Feb 8, 2018; OpenOffice has been very unstable (unexpected shut downs) since then. Sometimes the base file has been open (and was recovered) and sometimes it was not open.

Any help to recover this database will be much appreciated.
Last edited by vayaplaya on Tue Feb 20, 2018 12:08 am, edited 1 time in total.
Apache OpenOffice 4.1.5 with macOS High Sierra
vayaplaya
 
Posts: 5
Joined: Mon Feb 19, 2018 2:33 pm

Re: [Solved] Database unable to open

Postby nhsome3 » Mon Feb 19, 2018 6:35 pm

I am having an issue with opening an odb file. It sends me to select a filter. Not sure how to fix.


Thanks

OpenOffice 4.1.2 on Windows 10 pro
Openoffice 4.1.2 on windows 10 pro
nhsome3
 
Posts: 3
Joined: Mon Feb 19, 2018 6:29 pm

Re: [Solved] Database unable to open

Postby Sliderule » Mon Feb 19, 2018 6:47 pm

vayaplaya and/or nhsome3:

Since you cannot open your Base file ( *.odb ) . . . if you post your file here, or, some other file sharing link ( such as MediaFire https://www.mediafire.com/ ) so I can determine if I might be able to open the file ( at least the database portion ) . . . I will try to help.

Sliderule
User avatar
Sliderule
Volunteer
 
Posts: 1133
Joined: Thu Nov 29, 2007 9:46 am

Re: [Solved] Database unable to open

Postby nhsome3 » Mon Feb 19, 2018 7:23 pm

Openoffice 4.1.2 on windows 10 pro
nhsome3
 
Posts: 3
Joined: Mon Feb 19, 2018 6:29 pm

Re: [Solved] Database unable to open

Postby Sliderule » Mon Feb 19, 2018 7:35 pm

nhsome3 wrote:Here is a link to the file.
http://www.mediafire.com/file/gw5nm34zi3piw0z/cars.odb
Thanks

The above file link you gave, is extremely small in size ( 1536 bytes ) and, according to MediaFire, was uploaded 2013-11-19 09:40:32. Nothing internal to the file can be recovered . . . that is . . . changing to a zip file and repairing.

Sliderule
User avatar
Sliderule
Volunteer
 
Posts: 1133
Joined: Thu Nov 29, 2007 9:46 am

Re: [Solved] Database unable to open

Postby nhsome3 » Mon Feb 19, 2018 7:42 pm

Thanks,
Did not have much data. But it will take me a while to recreate all table designs. I have no idea on why it list that date. I just set up an account and uploaded it.
Openoffice 4.1.2 on windows 10 pro
nhsome3
 
Posts: 3
Joined: Mon Feb 19, 2018 6:29 pm

Re: [Solved] Database unable to open

Postby vayaplaya » Mon Feb 19, 2018 10:24 pm

This is the link from mediafire: http://www.mediafire.com/file/i58ndk84f ... Cloud2.odb. I hope you can do something with it.
Apache OpenOffice 4.1.5 with macOS High Sierra
vayaplaya
 
Posts: 5
Joined: Mon Feb 19, 2018 2:33 pm

Re: [Solved] Database unable to open

Postby Sliderule » Mon Feb 19, 2018 11:00 pm

vayaplaya wrote:This is the link from mediafire: http://www.mediafire.com/file/i58ndk84f ... Cloud2.odb. I hope you can do something with it.

I was able to 'restore' the database contents, that is, the HSQL 1.8.0.10 ( Embedded Database ), BUT, I was not able to recover any Queries, Forms, or, Reports.

In your database, the table "EventDescriptionTable1" contains 8104 records.

What should I now do with it, so, you can get it, assuming you want it?

Sliderule
User avatar
Sliderule
Volunteer
 
Posts: 1133
Joined: Thu Nov 29, 2007 9:46 am

Re: [Solved] Database unable to open

Postby vayaplaya » Mon Feb 19, 2018 11:25 pm

I do want it. The queries, forms and reports were seldom used and I can rebuild those. The data, especaily in EventDescriptionTable1 is most important to me. Thank you for your work.
Apache OpenOffice 4.1.5 with macOS High Sierra
vayaplaya
 
Posts: 5
Joined: Mon Feb 19, 2018 2:33 pm

Re: [Solved] Database unable to open

Postby Sliderule » Mon Feb 19, 2018 11:27 pm

So, ¿ do you want me to email it to you, or, post it on MediaFire ?
User avatar
Sliderule
Volunteer
 
Posts: 1133
Joined: Thu Nov 29, 2007 9:46 am

Re: [Solved] Database unable to open

Postby vayaplaya » Mon Feb 19, 2018 11:29 pm

If you would email it to me, that would be fine.

You must have magic fingers to to fix these database problems. Thanks.
Apache OpenOffice 4.1.5 with macOS High Sierra
vayaplaya
 
Posts: 5
Joined: Mon Feb 19, 2018 2:33 pm

Re: [Solved] Database unable to open

Postby Sliderule » Mon Feb 19, 2018 11:34 pm

vayaplaya wrote:If you would email it to me, that would be fine.

You must have magic fingers to to fix these database problems. Thanks.

Please PM ( Private Message ) me with your email address. I will send it ( the database file ) to you as an attachment. The file size ( bytes ) is now much smaller than before.

Sliderule
User avatar
Sliderule
Volunteer
 
Posts: 1133
Joined: Thu Nov 29, 2007 9:46 am

Re: [Solved] Database unable to open

Postby vayaplaya » Tue Feb 20, 2018 12:10 am

Sliderule brought my database back to life!
Apache OpenOffice 4.1.5 with macOS High Sierra
vayaplaya
 
Posts: 5
Joined: Mon Feb 19, 2018 2:33 pm

Re: [Solved] Database unable to open

Postby Villeroy » Tue Feb 20, 2018 9:36 pm

It deserves to live in a safe space now. [Python] Macro to extract and reconnect embedded HSQLDB
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 25381
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: [Solved] Database unable to open

Postby dunnock09 » Fri Feb 23, 2018 9:34 pm

I need to open my database YES the dreaded "provide a filter selection". Any help greatly appreciated.
openoffice 4.1.5
dunnock09
 
Posts: 2
Joined: Fri Feb 23, 2018 9:27 pm

Re: [Solved] Database unable to open

Postby Sliderule » Sat Feb 24, 2018 12:43 am

dunnock09 wrote:I need to open my database YES the dreaded "provide a filter selection". Any help greatly appreciated.

Since you cannot open your Base file ( *.odb ) . . . if you post your file here, or, some other file sharing link ( such as MediaFire https://www.mediafire.com/ ) so I can determine if I might be able to open the file ( at least the database portion ) . . . I will try to help.

Sliderule
User avatar
Sliderule
Volunteer
 
Posts: 1133
Joined: Thu Nov 29, 2007 9:46 am

Re: [Solved] Database unable to open

Postby dunnock09 » Sat Feb 24, 2018 2:07 am

Thanks for your speedy reply, I have now successfully found and opened an earlier version and everything I need is intact. Many thanks
openoffice 4.1.5
dunnock09
 
Posts: 2
Joined: Fri Feb 23, 2018 9:27 pm

Re: [Solved] Database unable to open

Postby azya123 » Wed Feb 28, 2018 1:35 pm

Hello. I have the same problem with database. I hope to get help from Sliderule. Link to corrupted db here http://www.mediafire.com/file/n6pzd91pf ... ise_db.rar
I tried to use python script from message above but corrupted database opens in librewriter, and this script doesn`t work from writer.
Thanks.(problem was solved by Villeroy in the message below)
Last edited by azya123 on Wed Feb 28, 2018 4:28 pm, edited 1 time in total.
Libreoffice 5.1.6.2 on Ubuntu 16.04
azya123
 
Posts: 2
Joined: Wed Feb 28, 2018 1:25 pm

Re: [Solved] Database unable to open

Postby Villeroy » Wed Feb 28, 2018 3:40 pm

Linux?
Code: Select all   Expand viewCollapse view
zip -F expertise_db.odb --out expertise._db.out.odb

restores the zip archive.
if not, try harder:
Code: Select all   Expand viewCollapse view
zip -FF expertise_db.odb --out expertise._db.out.odb

(your expertise_db requires only one -F)

Now you can reconnect the document to its embedded database (which is not the case yet) or you can extract the database from the document in order to get a more stable database solution. [Python] Macro to extract and reconnect embedded HSQLDB
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 25381
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: [Solved] Database unable to open

Postby azya123 » Wed Feb 28, 2018 4:26 pm

Villeroy, thank you. Problem is solved.
Libreoffice 5.1.6.2 on Ubuntu 16.04
azya123
 
Posts: 2
Joined: Wed Feb 28, 2018 1:25 pm

Re: [Solved] Database unable to open

Postby KbProblem » Wed Mar 21, 2018 7:08 pm

Hi,

i have kind of the same problem with my database... i've been using it for years and now as i wanted to open it and look something up it was broken. I can open the whole file but as soon as i want to open the table with all the data it shows me an error.
SQL-Status: S1000
Fehler-Code: -29

Can anybody help me with this problem?
OpenOffice 4.1.1 with Windows 10
KbProblem
 
Posts: 3
Joined: Wed Mar 21, 2018 6:56 pm

Re: [Solved] Database unable to open

Postby Sliderule » Thu Mar 22, 2018 5:27 am

KbProblem wrote:Hi,

i have kind of the same problem with my database... i've been using it for years and now as i wanted to open it and look something up it was broken. I can open the whole file but as soon as i want to open the table with all the data it shows me an error.
SQL-Status: S1000
Fehler-Code: -29

Can anybody help me with this problem?

Since you cannot open your Base file ( *.odb ) . . . if you post your file here, or, some other file sharing link ( such as MediaFire https://www.mediafire.com/ ) so I can determine if I might be able to open the file ( at least the database portion ) . . . I will try to help.

Sliderule
User avatar
Sliderule
Volunteer
 
Posts: 1133
Joined: Thu Nov 29, 2007 9:46 am

Re: [Solved] Database unable to open

Postby KbProblem » Thu Mar 22, 2018 9:54 pm

Oh, that would be great :)
http://www.mediafire.com/file/abzaubh4s ... nbank1.odb
Thank you very much!
OpenOffice 4.1.1 with Windows 10
KbProblem
 
Posts: 3
Joined: Wed Mar 21, 2018 6:56 pm

Re: [Solved] Database unable to open

Postby Sliderule » Thu Mar 22, 2018 10:13 pm

KbProblem:

The Base file database contents referenced above could not be recovered.

In your Base file, the database sub-directory, a data file did not exist, and, the backup file was corrupt.

Sliderule
User avatar
Sliderule
Volunteer
 
Posts: 1133
Joined: Thu Nov 29, 2007 9:46 am

Re: [Solved] Database unable to open

Postby KbProblem » Thu Mar 22, 2018 11:44 pm

Hmmm.... do you know why this did happen? Just curiousity.
OpenOffice 4.1.1 with Windows 10
KbProblem
 
Posts: 3
Joined: Wed Mar 21, 2018 6:56 pm

Re: [Solved] Database unable to open

Postby Sliderule » Thu Mar 22, 2018 11:50 pm

KbProblem wrote:Hmmm.... do you know why this did happen? Just curiousity.

In all probability you shut down your computer and the OpenOffice / LibreOffice program before it completed writing the file to the storage location. It has never happened to me, very long time I have used OpenOffice on any application.

Since I was not present when it happened to your file, I cannot say with any degree of certainty.
User avatar
Sliderule
Volunteer
 
Posts: 1133
Joined: Thu Nov 29, 2007 9:46 am

PreviousNext

Return to Base

Who is online

Users browsing this forum: No registered users and 3 guests