[Solved] Database unable to open

[Sliderule]

BarneyinOZ

I just sent you a PM ( Private Message ).

Sliderule

[Hendrie]

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

[Hendrie]

With regard to previous post the errors are reported as :

SQL Status: S1000 Error code: -37 User not found: SA

[Hendrie]

Fingers crossed I now seem to have recovered the data from the last backup file that wasn't O kb in length.

[vayaplaya]

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.

[nhsome3]

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

[Sliderule]

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

[nhsome3]

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

[Sliderule]

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

[nhsome3]

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.

[vayaplaya]

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

[Sliderule]

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

[vayaplaya]

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.

[Sliderule]

So, ¿ do you want me to email it to you, or, post it on MediaFire ?

[vayaplaya]

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

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

[Sliderule]

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

[vayaplaya]

Sliderule brought my database back to life!

[Villeroy]

It deserves to live in a safe space now. [Python] Macro to extract and reconnect embedded HSQLDB

[dunnock09]

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

[Sliderule]

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

[dunnock09]

Thanks for your speedy reply, I have now successfully found and opened an earlier version and everything I need is intact. Many thanks

[azya123]

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)

[Villeroy]

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

[azya123]

Villeroy, thank you. Problem is solved.

[KbProblem]

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?

[Sliderule]

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

[KbProblem]

Oh, that would be great
http://www.mediafire.com/file/abzaubh4s ... nbank1.odb
Thank you very much!

[Sliderule]

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

[KbProblem]

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

[Sliderule]

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.