Page 1 of 1

[Solved] The document " " could not be opened

Posted: Tue Dec 31, 2019 5:06 am
by JohnKarim
Hi

My reports suddenly stop working, the error message is OpenOffice base the document "Report" could not be opened. all queries are working well. I am using oracle report builder.

can anyone please help.

Thanks

John

Re: openoffice base the document " " could not be opened

Posted: Tue Dec 31, 2019 10:40 am
by F3K Total
Hello,
have you installed and then selected a 32-bit Java-version in Menu /Tools/Options ... OpenOffice-> Java?

Re: openoffice base the document " " could not be opened

Posted: Wed Jan 01, 2020 3:12 am
by JohnKarim
java is installed, i didnt find to change to 32bit. and i had oracle report builder installed but now nothing on extension option.

Re: openoffice base the document " " could not be opened

Posted: Wed Jan 01, 2020 2:20 pm
by Villeroy
Your Java is installed in "C:\Program Files (x86)\" which is the place where a 64-bit Windows installs 32-bit software. This is the correct Java for OpenOffice which is also installed in C:\Program Files (x86).
If the report required a special extension, the error message would be about the missing extension. I've never seen your error message when opening a report. I think, the reports are broken somehow.
You can recreate the reports even from an older backup copy of the database document without touching the data in your database.
Make a new backup copy of the current database (just in case).
Open the current database, delete all reports. If the report icons do not disappear, save, close and reopen the document. Now the report section should be empty.
Open the old backup where the reports are still intact and copy the report icons into the report section of your current database. Drag&drop should work as well if you arrange both document windows side by side.

Re: openoffice base the document " " could not be opened

Posted: Wed Jan 01, 2020 11:14 pm
by JohnKarim
Thanks Guys, Its all good now.